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.
I need to create a combined graph with two columns and a percentage line.
But when I select two filters from the same column, the graph line is not recalculating the percentage, it only shows the result as average, sum, standard deviation and others.
Is there any solution for this?
Example:
Slicers | Data1 | Data2 | Percentage % |
Name1 | 1,500,000 | 7,300,000 | 21% |
Name2 | 16,300,000 | 36,100,000 | 45% |
17,800,000 | 43,400,000 | 41% |
I need select: Name1 + Name2 with slicers and i need see 41% as value, not average, not sum, etc.
Thanks you!
You just need to add a measure.
Measure = DIVIDE ( SUM ( Table1[Data1] ), SUM ( Table1[Data2] ) )
I have a measure in a card with the global result of the division, which works correctly with the slicers. But i can not use a measure in a combined graph, only was use columns calculated or normal.
In data i have more columns with month, year, area and others.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |