cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Looking for a specific visual (ratio and percentage between two measures)

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!

1 ACCEPTED SOLUTION
Community Support

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:

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
3 REPLIES 3
Super User

@pmaurizi, No very clear

Ratio = divide([Measure1],[Measure2])

Or

Ratio = divide([Measure2],[Measure1])

% of total = divide([Measure1],calculate([Measure1],all(Table)))

Frequent Visitor

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!

Community Support

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:

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors