Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
agusti_oliveres
Frequent Visitor

Show the percentage of the highlighted part

Hi, I have a dashboard with two bar charts like this:

charts1.PNG

When I filter one of them, the other highlights the corresponding part (as expected). For example:

charts2.PNG

The problem I have is that I would like to show the percentage of each highlighted bar in the black box that appears when you move the mouse over it. By default, it shows only the absolut value of the higlighted part, and I would like to add the percentage value (in this case would be 158,488.85 / 1,278,160.22 * 100). Can anyone help me with that?

 

Thank you.

Agustí

1 ACCEPTED SOLUTION

So, you should be able to create measures along the lines of:

 

% Selected = DIVIDE(CALCULATE(<something>,FILTER(ALLSELECTED(Table))),CALCULATE(<something>,FILTER(ALL(Table))))

For example. Then you should be able to place those measures in your tooltip page. Then when you hover over your bar chart, it should show you the information that you desire.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
harshabns8
Frequent Visitor

Hi,

I wanted to know how you solved the showing percentage thing. 

 

Thanks,

Harsha

harshabns8
Frequent Visitor

Hi,

I wanted to know how you solved the showing percentage thing. 

 

Thanks,

Harsha

danielkari
Regular Visitor

What if I have already selected time period and would like to calculate the propotion within the time period? 

Greg_Deckler
Super User
Super User

Check out the March version that includes the new Tooltips pages feature. It is SPECTACULAR!!! and I think can get you where you need to be because it essentially gives you complete control over the tooltip.

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2018-feature-summary/

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Okay thank you! I see it's an amazing update. I will definetly use it.

But still I haven't figured out how to show the value I need. I would like to show the total value of the bar, the highlighted part (these two are already shown by default) and the percentage of the highlighted part over the total value (that's the new measure I want to show). 

Any ideas?

 

Thank you.

So, you should be able to create measures along the lines of:

 

% Selected = DIVIDE(CALCULATE(<something>,FILTER(ALLSELECTED(Table))),CALCULATE(<something>,FILTER(ALL(Table))))

For example. Then you should be able to place those measures in your tooltip page. Then when you hover over your bar chart, it should show you the information that you desire.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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