cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## 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
Community Support

HI @Galoyol84,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
3 REPLIES 3
Community Champion

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
Helper I

I would like to end up with this

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

Community Support

HI @Galoyol84,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.