locked
group data in X-axis RRS feed

  • Question

  • Hi,

    I have a table as below and I would like to create a chart next to the table. I don't to know how to set Jan data as a group and Feb as another group. Please help and thanks

    Tuesday, August 15, 2017 11:52 AM

Answers

  • Hi Dom,

    Thanks for your question.

    In this scenario, you can use visualization "Stacked column chart".

    In the fields settings, drag Month and Product columns to Axis, drag region-product to Legend, drag Produce to value.

    In the format settings, set Position to Right for Legend, set Concatenate Labels to off for X-Axis.

    According to your description, your problem is more related to PowerBI. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in PowerBI forum : http://community.powerbi.com ,you will get a more professional support from there, thank you for your understanding and support.

    One more thing, please kindly mark the helpful replies as answers. By doing so, it will benefit all community members who are facing similar issues. Your contribution is highly appreciated.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Wednesday, August 16, 2017 2:30 AM

All replies

  • refer following example

    http://www.bluepecantraining.com/portfolio/grouping-date-fields-in-excels-power-pivot/


    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx https://social.technet.microsoft.com/wiki/contents/articles/37856.sql-server-on-linux-how-to-change-sa-password.aspx


    • Edited by AV111Editor Tuesday, August 15, 2017 2:12 PM
    Tuesday, August 15, 2017 2:12 PM
    Answerer
  • Hi Vishe

    I think my question is not clear enough. I mean I want to do it power BI. How can I do it? I can do it in Excel.

    thanks

    Wednesday, August 16, 2017 1:42 AM
  • Hi Dom,

    Thanks for your question.

    In this scenario, you can use visualization "Stacked column chart".

    In the fields settings, drag Month and Product columns to Axis, drag region-product to Legend, drag Produce to value.

    In the format settings, set Position to Right for Legend, set Concatenate Labels to off for X-Axis.

    According to your description, your problem is more related to PowerBI. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in PowerBI forum : http://community.powerbi.com ,you will get a more professional support from there, thank you for your understanding and support.

    One more thing, please kindly mark the helpful replies as answers. By doing so, it will benefit all community members who are facing similar issues. Your contribution is highly appreciated.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Wednesday, August 16, 2017 2:30 AM
  • Excel 2016 Pro Plus with PowerPivot and Power Query (aka Get & Transform)
    With real dates. No concatenation.
    http://www.mediafire.com/file/78b48b7h94d8qc8/08_15_17a.xlsx
    http://www.mediafire.com/file/rs1yajwx47f8gk2/08_15_17a.pdf


    Wednesday, August 16, 2017 2:42 AM
  • Thanks for your reply and . I follow your instructions to reproduce and use the date from your link, but I can't reproduce it.

    http://www.mediafire.com/file/78b48b7h94d8qc8/08_15_17a.xlsx

    Wednesday, August 16, 2017 6:24 AM
  • Hi Dom,

    Thanks for your response.

    Did you test it with your own sample data ? As you can see from my reply, it is exactly what you are after.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, August 16, 2017 6:37 AM