Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
following is the problem: I would like to display field values in a visual card through the usage of a hierarchy slicer.
However, when picking a value from the slicer, the results presented in the visual card is the SUM of all sub hierarchies, not the field value associated with the selected value.
Example Hierarchy Slicer Setup
Dept. Group
Dept A
Dept B
Example Table
Dept. Group 100
Dept A 50
Dept B 50
If I click on the Slicer Dept. Group the return value is 200, but the desired outcome is 100. There is no option to turn off the sum function the visual card.
Also, the format of the values needs to stay numbers and not converted into text.
Thanks for any tips!
I suspect your table structure is the problem. If you restructure your table to then I think you will get what you're looking for... more details below
Group | Dept | Amount |
Dept. Group | Dept A | 50 |
Dept. Group | Dept B | 50 |
Create a hierarchy on Group and Dept and use that in your slicer.
Create a measure to sum the amount and put that in your card.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |