cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sfmike99
Advocate II
Advocate II

Showing totals and slicer selections in bar chart

 

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?

 

sfmike99_0-1611270646570.png

 

 

 

5 REPLIES 5
v-robertq-msft
Community Support
Community Support

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?

v-robertq-msft_0-1611654366379.png

 

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.

sfmike99_0-1611676495523.png

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.

amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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": 

sfmike99_0-1611607608934.png

 

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.



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors