Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
48 | |
31 | |
27 | |
26 | |
26 |
User | Count |
---|---|
60 | |
56 | |
36 | |
32 | |
28 |