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.
I have a few line & bar charts similiar to the attached with show information based on departments. I have a request that in the tooltip I show not only the value per department - but also the total sum of all departments (in this case 4,732,413). The data source is a tabular cube and the value is a measure within the cube.
I searched thru the options for the charts and seeing nothing there I believe I need some DAX to accomplish this? So far, I am unsuccessful at writing any DAX that when combined into this chart avoids being filtered by department... Is there anyone who can give me a hint to get me started on the right path?
The line chart and the bar chart are two different areas of my same tabular cube - and both have the same request to have the grand total as well as the sliced values... (edited to add that second photo)
Solved! Go to Solution.
I'm a little confused - I already have the divided value - I need the summed value...
Both Calculate & All display the sliced value when added as a measure to the tooltip.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |