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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
Anonymous
Not applicable

Pin selection from slicer

Hello Community,

 

I'm trying to create a line chart to show the results of an indicator by country and by year. Additionally I would like to have the region value all the time so I can compare specific results.

 

What I had in mind was to add a DAX expression in the filters. I came up with this measure:

 

default country =
IF(
CALCULATE(ISFILTERED(FactCountryIndicator[Country]),ALLSELECTED(FactCountryIndicator[Country]),SELECTEDVALUE(FactCountryIndicator[Latin America & the Caribbean])
))))
 
But it is not working.
 
Any help would be appreciated
 
PS
I share the file
1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Anonymous,

AFAIK, power bi does not support setting the default value of filter/slicers. (Dax formulas also not support direct interaction with the filter/slicer section)

For this scenario, you can use unrelated table 'country' field on the slicer and create measure formula with conditions to set a default value and compare with current value to return tag. (you can use it on visual level filter use the result tag to confirm displayed records)

Calculate table:

Country Selector= ALL( Table[Country] )

Measure:

Measure filter on Slicer =
VAR currValue =
    SELECTEDVALUE ( Table[Country] )
VAR default = "Latin America and the Caribbean"
RETURN
    IF ( currValue <> default , "Y", "N" )

After these steps, you can write a measure as filter on your line chart to check current value and selected value from slicer.

Measure filter on Chart =
VAR currValue =
    SELECTEDVALUE ( Table[Country] )
VAR default = "Latin America and the Caribbean"
VAR selected =
    ALLSELECTED ( 'Country Selector'[Country] )
RETURN
    IF ( currValue IN selected || currValue = default, "Y", "N" )

Regards,

Xiaoxin Sheng

View solution in original post

3 REPLIES 3
az38
Community Champion
Community Champion

@Anonymous 

try to create column, not measure

but i can not to understand what result do you expect


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

I would like to end up with this

 

Captura de pantalla 2020-05-13 a la(s) 17.05.03.png

Hence you can select more countries and compare them with the region.

 

In my model what I have is a column of indicators  with four of them and information about five countries plus Latin America and the Caribbean.

 

PS I don't want that Latin America shows in the slicer, just in the chart 

 

Anonymous
Not applicable

HI @Anonymous,

AFAIK, power bi does not support setting the default value of filter/slicers. (Dax formulas also not support direct interaction with the filter/slicer section)

For this scenario, you can use unrelated table 'country' field on the slicer and create measure formula with conditions to set a default value and compare with current value to return tag. (you can use it on visual level filter use the result tag to confirm displayed records)

Calculate table:

Country Selector= ALL( Table[Country] )

Measure:

Measure filter on Slicer =
VAR currValue =
    SELECTEDVALUE ( Table[Country] )
VAR default = "Latin America and the Caribbean"
RETURN
    IF ( currValue <> default , "Y", "N" )

After these steps, you can write a measure as filter on your line chart to check current value and selected value from slicer.

Measure filter on Chart =
VAR currValue =
    SELECTEDVALUE ( Table[Country] )
VAR default = "Latin America and the Caribbean"
VAR selected =
    ALLSELECTED ( 'Country Selector'[Country] )
RETURN
    IF ( currValue IN selected || currValue = default, "Y", "N" )

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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