Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
User | Count |
---|---|
92 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
156 | |
145 | |
105 | |
72 | |
55 |