Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The other day I accidentally stumbled across something interesting: if I change my slicers to tables, then the linked visuals will preserve the "pre-slicer" values for comparison. This is a very interesting view as it lets you quickly assess how much your selection differs from the whole population, but it only works if I'm using tables instead of slicers. This is similar to using the "ALL" function in DAX, except no coding required and the UI is taken care of. Is it possible to do the same thing with slicers using DAX? I know I could get the unfiltered data, but could I replicate that UI?
Hi, @sfmike99
According to your description and sample picture, you said that when you changed your Slicer into a table chart, the visual displayed like this, right?
I think you are talking about the highlight interaction in Power BI, you can check this document:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters-and-highlighting
I don’t think it can be achieved if you are using Slicer in Power BI.
You can go to the Power BI Idea to post a new idea.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ah I think you're right. In fact the term I was looking for is "cross-highlighting" and it is one of the options when you edit interactions. Unfortunately it seems that option works for every visualization I tried except for slicers. This is too bad, because I think that is the easiest way to quickly compare your selection with the overall population. I will submit an idea.
Middle option is missing when the visualization is a Slicer 😞
Idea submitted: https://ideas.powerbi.com/ideas/idea/?ideaid=683ac540-f05f-eb11-8fed-501ac50aa35e
Hi, @sfmike99
Yes, the interaction option is applied to almost all visuals except the Slicer in Power BI. I think it’s because the only function for Slicer is to slice the data at current. Maybe more types of data filtering tools will come out in the future in Power BI.
I’ve also voted for your idea.😁
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sfmike99 , You can use allexcept and all .
Assume measure is filtered
new measure = calculate([measure], allexcept(table, Table[region]) //only regional filter will apply
new measure = calculate([measure], all(table) // all filter will be removed
You can also create a tooltip page using these measure
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
Thank you @amitchandak . As I mentioned, I'm familiar with using ALL in measures, but I'm interested in recreating the UI that appears in the above examples. I know I can overlay a line to show all the data with the "Line and Stacked Column Chart":
But is there a visualization that works like the one shown in my original post? That's what I'm looking for but without having to filter through a table.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |