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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Kristinfortner
Frequent Visitor

Compare filtered data to overall data

Is there a way to show the overall data and data filtered by customer in the chart format below? If not, how can this be done? We want to be able to see the customer data and filtered data on a double or stacked bar for each value. 

Kristinfortner_0-1677684836603.png

 

1 REPLY 1
edhans
Super User
Super User

Yes, you just need to remove the customer filter to see all the data. So if the measure generating that data is [Customer Sentiment] then the following measure will break out of the filtered customer:

All Customers =
CALCULATE (
    [Customer Sentiment],
    REMOVEFILTERS ( Customers )
)

So no matter what is selected in the filter or slicer, that measure will ignore it and show all Customers. (Assuming your customers are in a table called Customers.)

If that isn't what you need, or want more help, we need more info. See below.

 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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