Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I'm trying to create a tooltip that returns the percentage(proportion) of the total amount for each distinct company in a bar chart.
I've created a measure with the following DAX code to use as a tooltip:
When I create a table visual that lists each individual Company and add this measure to that table, it responds with the correct results.
When I hover over each individual Company in the Bar chart to view the tooltip results, I'm getting wierd numbers. Basically, I'm getting a denominator which only contains the value of that highlighted company WITHOUT any page filters
I've also tried the following DAX functions and they havent provide the correct results:
@Bullet_Train95 , Try like
% of total = divide(SUM('Contract Register Sheet'[Original Value]),CALCULATE(SUm('Contract Register Sheet'[Original Value]),ALL('Contract Register Sheet')))*100
No need to multiply by 100, you can mark it as % column
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Hi there,
When I use
% of total = divide(SUM('Contract Register Sheet'[Original Value]),CALCULATE(SUm('Contract Register Sheet'[Original Value]),ALL('Contract Register Sheet')))
The value ends up being double the correct value for some reason. Why is that?
Hi @Bullet_Train95 ,
In order to get a better understanding on your requirement and give you a suitable solution, could you please provide some raw data in your tables (exclude sensitive data) with Text format, your visual settings and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
User | Count |
---|---|
93 | |
87 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |