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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

What is a return of selectedvalue if none is selected but the slicer is showing all?



I have 17 regions in the Region column and I need to create a table with dynamic names. For slicer I have activated "Multiple Choice with CTRL", it means that If nothing is selected, the values will be shown for all regions. Here comes my question: How can I write in DAX, if nothing selected my table name is: Entire country, otherwise region names from the slicer.


so far I tried:


IF((SELECTEDVALUE('Region')), "Entire country", SELECTEDVALUE('Region')))
Helper IV
Helper IV

@Anonymous Do you want to Dynamically change the Heading  as per the selection from slicer? If Yes,then you can try below dax:_

Text = IF(ISFILTERED('TableName'[ColumnName]), SELECTEDVALUE('TableName'[ColumnName]),"Entire Countries")
Not applicable

In my slicer options are selected with CTRL, if there is no selection it shows "ALL". with your dax equation the result empty if i do not select region, but if I select it works. So I want, if slicer shows me "ALL" I want to see "Entire country" name on my table, otherwise selected region names.

@Anonymous I have implemented same scenario, I have used Genre related dataset.




for me it is working...can you share your .pbix file?

for me is not


Community Champion
Community Champion

Hi @Anonymous ,

with a slicer, something is always selected! For the selection "Select all" there are two settings in the slicer (see figure). Combinations of the slicer selection can be executed with the CTRL key. If you want to get the selected values use the above measure CONCATENATEX(...).




With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Not applicable

Thanks for your reply. I got your idea, but I do not need all these city names, I want to have only one name. For example for your data: Germany.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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