Forum Discussion
Power BI graph not show same with Excel graph
Hello, I am the beginner of Power BI, Would like to ask the graph question.
In the excel shows month together for each valueX
But for the same data in Power BI
The Value1 and Value2 show together for each month
Anyway to show the same with excel ?
In Power BI, you need to modify the structure of the table to make it fit for the column chart. You can use Power Query Editor to do that. Below are my steps.
1. Open Power Query Editor from Home > Transform data.
2. Select Value1 and Value2 columns at the same time. Unpivot them from Transform > Unpivot Columns.
3. Close Power Query Editor and apply the change to Power BI Desktop.
4. When creating a column chart, add Attribute to X-axis, add Value to Y-axis and add Month to Legend.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
6 Replies
- ChristianDGreat
Resolver I
Actually this is possible but need some modification.
Is the excel version is the one you really want to mimic?Yes, it is.... 🙂
- ChristianDGreat
Are you looking to have the month right here as well?
- SpartaBI
Community Champion
fastspeed33_BI
Here is a link to download a sample solution file:
Power BI graph not show same with Excel graph 2022-08-10.pbix
