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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
nic_learner
Frequent Visitor

HOW TO SHOW A SPECIFIC VALUE WHEN NO FILTERS ARE SELECTED

Hi! 

 

I'm still learning tips and tricks about PowerBI. Right now I'm trying to use the card visual to show a specific measure. I have four levels of filters. If no filter is selected, I want to show a certain value (e.g. 4.43), if choose level 1 filter and no other filters, then it would show another value (4.42), and so on. However, Power BI summarizes the data and if I choose no filter, it will average/sum/count/etc. all the values in the column measure. So, I would like to know if anyone has a solution/workaround to this? I would greatly appreciate if somebody can help me with this.

 

This is an example of my data:

nic_learner_0-1659027691930.png

Thanks in advance!

 

3 REPLIES 3
lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi Ibendlin, here is the link to find sample data for my question: Sample Data 

I have engagement scores for my company and its divisions. In the dashboard, I created 3 filters: Business Unit, Division and Department Name. If I don't select any filter, it means I am showing the company overall score (4.50). If only want to filter by Business Unit and select HeadOffice, the result should be 2.10. The empty cells refer to when there is no filter selected in that level.

 

Hope this makes it clear and thank you for helping out!

Thank you for providing the sample data. That helps a lot with proposing a potential solution.

 

Your expected result is not supported by the facts you provided.  For stores you have an average engagement of 3.8 but your individual store values are 

lbendlin_0-1659463895968.png

All of these are lower than 3.8, so even with weighting there is no way to reach that average.

 

Note:   In general you don't need to do the manual roll-ups, you can let the data do the work for you.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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