cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Justair07 Member
Member

Show Defaulted Value for All Data When Nothing is Selected in a Slicer

Hi,

 

I have a table that contains data for the entire Factory as a whole and broken up into different Areas.

 

On my combo chart I have a bar that displays the Total Value for either a selected area (I'm using a slicer) or the Total Value for ALL areas (Factory) if nothing is selected in the slicer.

 

Each area has a Target % that I use to determine the Target Value (see picture of sample data below)table.JPG.

Target Value = (Total Value * Target %)

 

This works great when the user is selected on a specific area.

 

The problem is that when I want to see the correct target value for the Factory as a whole, Power BI uses the aggregated percentage of all areas to determine the target % thus the target value. I want the target % for the factory to be defaulted to 5% when nothing is selected.

 

I hope I explained this well enough to make sense. Not sure if anyone has any tips for me to accomplish this.

 

Edit: Here is my attempt:

 

Target Test % = IF( ISFILTERED('Value Stre'[Dept]),MAX('tblWaste'[Target $]),.077)
 
But now it just reverts to .077 no matter what. Am I focusing on the wrong column for the ISFILTERED function?

 

Thank you,

 

- Justin

2 REPLIES 2
v-cherch-msft Super Contributor
Super Contributor

Re: Show Defaulted Value for All Data When Nothing is Selected in a Slicer

Hi @Justair07

 

You may have a look at this article about HASONEVALUE vs. ISFILTERED vs. HASONEFILTER functions and ISINSCOPE function.If you need further help,sample data and expected output will be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

 

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Justair07 Member
Member

Re: Show Defaulted Value for All Data When Nothing is Selected in a Slicer

@v-cherch-msft Thank you very much, I will look into this and reply back.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 273 members 2,924 guests
Please welcome our newest community members: