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 have a table like this,
How to get graph, having JAN and FEB on X-axis, with sum of A JAN and T JAN for JAN and sum of A FEB and T FEB for FEB.
Thanks!
Solved! Go to Solution.
Hi @NithinBN
Wasn't sure exactly what you wanted but this PBIX file contains both of these charts
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi @NithinBN
Wasn't sure exactly what you wanted but this PBIX file contains both of these charts
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi,
Is this the result you're looking for?
To get this I transformed the table in Power Query Editor with these steps:
1. Created a new 'JAN' column that summed the values from columns 'A JAN' and 'T JAN'
2. Created a new 'FEB' column that summed the values from columns 'A FEB' and 'T FEB'
3. Removed all columns other than 'JAN' and 'FEB'
4. Then highlighted the 'JAN' and 'FEB columns and unpivoted the table.
You can then create the above graph. Hope that was the type of solution you were looking for!
Jo
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |