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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
unasolveig
New Member

KPI to show total when nothing selected in slicer

Hello, 

 

I'm very new to Power BI and already I'm a big fan, I've tried to find an answer to my question that is probably very basic but have had no luck. 

 

I work in healthcare and I've included the KPI visualization in my report where I'm displaying how much over or under budget each unit is. When I use the slicer it will correctly show how much over or under budget the corresponding unit is. However, when I'm looking at all the units at once I'd like the KPI to show the overall number of how much under/over budget we were as a whole but it now always displays the outcome for the same unit - which I don't want specifically highlighted like that. So if I can't have it show the overall savings can I at least make it not highlight one unit over the others?

 

Thank you for reading my question 😄 

4 REPLIES 4
unasolveig
New Member

hi, 

 

thank you so much for your reply. Unfortunately because of the nature of my workplace I don't have permission to share the data. I will attempt to explain how my data is built and how I used it (to complecate it even more my data is in Icelandic). I did it like this:

 

unasolveig_0-1695200633325.png

Deild= units (the names of the units)

Measure is a variable I created as the goal where all the cells contain the value 0 (we want each unit to be on budget and now red is a high number (over budget) and green is a low number ( negative numbers are under budget)

 

Sum of umfram kostnaður= a variable where I subtracted the actual spending from the budgeted amount.

 

I hope that this makes some sense, but I understand that I might be going completely the wrong way about using this visual as I'm very new to Power Bi and am just figuring it out as I go. 

 

 

 

I would need to see the actual DAX of the measure and a sample of your raw data. I understand you can't share real data, but if you can create an example with mock data, that would help. 

unasolveig_0-1695638364834.png

This is how I had set it up but with mock numbers. As you can see when I don't select anything in the slicer it shows the overspending of unit e. The DAX of my measure is super basic (maybe thats my problem?) 

CoreyP
Solution Sage
Solution Sage

Please share your measure and an example of your data.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.