slicer selected column

2 Topics

Dax query for making slicer with column name
Hi Everyone, I wanted to create a slicer based on column name I have created a visual based on two column 2021 and 2022 data, but I want a slicer name "2021" and "2022" And when I click on 2021, it show visual values of 2021 Light Blue one and same for 2022 Dark Blue one And If I don't click on anyone of slicer it shows the following Thank you
Solved
Anonymous
4 years ago Place DAX Commands and Tips
943Views
0likes
3Comments
How to reference a COLUMN used as slicer in order to use it inside a MEASURE
Hello Community, Is there a way to reference THE COLUMN NAME of the slicer (in the form "Table"[Column]) inside of a measure ? The reason I need this is because I want to have a different TITLE for the slicer visual, which will differ, depending on the column selected. And in order to get that, I need to use a FORMULA (measure) in the TITLE section which handles the title output depending on the column. But I can't reference it in any way. Sadly there is no ISSELECTED for columns, and I need to find an alternative. And it also has to work without a selected value necessarily (so SELECTEDVALUE("Table"[Column]) command is also no good). The title needs to be different then the column selected, because all these slicer columns have an abstract naming (eg name_1, name_2 ), used to avoid breaking the model upon online refreshing. The actual names are created by users and can be anything really and may be subject to change. This will be outputed by the dynamic title created from the measure, but this is the easier part. So in other words I am looking for something like : Measure Title = IF(...SELECTEDCOLUMNOFSLICER(Table[name_1]) = TRUE ... ,"value1", IF(...SELECTEDCOLUMNOFSLICER(Table[name_2]) = TRUE ... ,"value2") ) Thank you for your time on this, Kind regards,
Solved
ioanik
4 years ago Place DAX Commands and Tips
3.2KViews
0likes
4Comments