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, everybody,
I need to know if exists a visual that allows to place 2 measures, and shows the ratio between both measures, and the percentage between that ratio and one of them.
Something similar to KPI visual, but a little different
For example:
Measure 1: Operating expenses
Measure 2: EBITDA
I need to show the ratio between Measure 1 and Measure 2, and also the percentage that this ratio represents over Measure 1
Thank you very much in advance!
Solved! Go to Solution.
Hi @pmaurizi
Based on my research, there's no visual available per your requirement currently.
Please kindly raise the idea in the portal to bring the new visual coming:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
@pmaurizi, No very clear
Ratio = divide([Measure1],[Measure2])
Or
Ratio = divide([Measure2],[Measure1])
% of total = divide([Measure1],calculate([Measure1],all(Table)))
Hi Amit, thanks for your answer.
You're right, maybe I wasn't very clear, sorry.
I'll try to explain better.
I know that DAX, what I need to know is, for this case, if there is a visual that replaces DAX.
I mean, that I can put in fields Value of the visual, the two measures, and then the visual calculate the ratio and percentage.
I have to show many indicators in one page, and I would like to do it with visuals, avoiding to build many dax, if it's possible.
Something similar to what the KPI standard visual does with the value and the target, where it returns the difference and the percentage.
Thank you!
Hi @pmaurizi
Based on my research, there's no visual available per your requirement currently.
Please kindly raise the idea in the portal to bring the new visual coming:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |