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.
Hi,
I have a clustered bar visual that can go in either direction, depending on if the deviation is positive or negative.
I have two issues. The current graph looks like this. The report is supposed to be dynamic, so if I filter for a different department, the numbers will change, and maybe the grey bar will deviate the most. Therefore I can't adjust the X-axis to a fixed number.
I'd like to:
Any help is appreciated.
Hi @rhl94 ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please free to ask.
Best Regards,
Cherry
Hi @rhl94 ,
If I understand your requirement correctly that you want to calculate the MIM or MAX of the multiple measures.
I'm afraid that the there is no direct functions in dax to achieve that.
I think you could create a variable calculated table with the measures and the calculate the max and min measure.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |