cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ppgandhi11 Helper V
Helper V

How to display filter values on same page as filter itself?

Hi,

 

I have about 5 filters on page1. each of them is a long list. There is a visual on the lower half. Every time user has to scroll through each of the filters to see which ones are selected. Is there any way that I can display the selected filter values on the same page along with visual? This would make it much easier for users to see which filters are used and with what values instead of scrolling each of them.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Phil_Seamark
Microsoft

Re: How to display filter values on same page as filter itself?

Hi @ppgandhi11

 

You can create a calculated measure similar to the following and just drag it to a Card Visual on your report canvas.  It will display the currently selected value from the table[column] from your slicer.

 

Measure = SELECTEDVALUE('Table 2'[Column]) 

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
Microsoft Phil_Seamark
Microsoft

Re: How to display filter values on same page as filter itself?

Hi @ppgandhi11

 

You can create a calculated measure similar to the following and just drag it to a Card Visual on your report canvas.  It will display the currently selected value from the table[column] from your slicer.

 

Measure = SELECTEDVALUE('Table 2'[Column]) 

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

v-piga-msft Resident Rockstar
Resident Rockstar

Re: How to display filter values on same page as filter itself?

Hi @ppgandhi11,

 

For another option, if you only select one value for each Slicer, you could select the Dropdown type of Slicer which should meet your requirement.

 

If you only select one value it will show the value you selected. If you select mutiple values, it will show Multiple selections.

 

Slicer.PNG

 

 

Hope this also can help you!

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ppgandhi11 Helper V
Helper V

Re: How to display filter values on same page as filter itself?

@Phil_Seamark

 

It works! Thanks.

reddy_powerbi Post Patron
Post Patron

Re: How to display filter values on same page as filter itself?

@Phil_Seamark if we select multiple values then how can we do it?

 Using  SELECTEDVALUE(table[column],"All") ,  it will show 'All' even for multiple values.  How can we make it work for three scenarios
single select, multiple values , All?
Anonymous
Not applicable

Re: How to display filter values on same page as filter itself?


This is the method I've used. The measure below will return nothing ("") if the 'Products'[Type] field isn't filtered. If that column has been filtered and there are more than 5 rows selected then it returns "Multiple". Otherwise, I use CONCATENATEX to grab all the values selected and use a comma and space to seperate each value of 'Products'[Type]. Before the CONCATENATEX I have some other text that will concatenate some user friendly text. If a user selects 2 Products[Type] values the whole measure will return "| Type - Type Selection 1, Type Selection 2". So I then repeat this measure for each column in the table that might have a filter selected by the user.
Selected Type =
IF (
ISFILTERED ( 'Products'[Type] ),
IF (
    COUNTROWS ( VALUES ('Products'[Type] ) ) >=5,
    "Multiple",
    " | Type - "&
        CONCATENATEX ( VALUES ( 'Products'[Type]), 'Products'[Type], ", " )

         )
    ),
    ""
    )
)
Then I add a measure that concatenates all the selection measures and put them in a visualization that supports text, like a card. The final measure might look like [Selections] = [Selected Type]&[Selected Sub Type]. I don't have worry about separating text because those are in the selection measures. Result example: "| Type - Type 1 | Sub Type - Sub Type 1, Sub Type 2".

svoves Resolver I
Resolver I

Re: How to display filter values on same page as filter itself?

I know you have already marked as solved but here is a great post from Power Pivot Pro that goes into a little more detail that I often refer to. https://powerpivotpro.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors