Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
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.
@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
Actually this is possible but need some modification.
Is the excel version is the one you really want to mimic?
Yes, it is.... 🙂
Are you looking to have the month right here as well?
Actually, no need, only group month 1 and 2 together for each ValueX
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |