Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I'm new in the community, sorry if I make any mistake, today I need help but hopefuly I'll be able to help others soon.
Basically I build a Measure to built my % of Grand Total but I have 15 different Visuals, all use same Value (My Measure) but the Axis are different. If I apply my formula:
If it's possible, would save me a big mess with measures and also learn more about DAX. Otherwise I'll need to change the Table[A] to Table[B] then Table[C] ...D...G...Z..
@Anonymous
I think you are looking for dynamic axis solution :
https://www.youtube.com/watch?v=dYmzb5UMkXw
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy
That was a very interesting way too but, in case I already have the visual as part of my dashboard also approved by the company and stuffs.
In that case I want to be able to use the same formula in all the different Visuals just using this way to use the Axis names as the Main one to define what they will look for to make the calculation.
Hope it make some sense, I really don't like to bother ppl, but I'm quite stuck on it.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |