Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create a slicer using multiple columns of a table - NOT NESTED

I want to create slicers that list categories representing multiple different columns in my dataset in a non-nested way.   For example, I have in my central demographics table a bunch of columns re...
Need Help
lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi ji
here the link of the pbix
https://we.tl/t-6Xtz2nj6sQ
You have to manage two table that corrispond to two parameter.
They manage you column.
The first parameter "Columns ever show" is the first column of your table and are show indipendent from the choose of your slicer FE.
The secondo parameter "Column Parameter" show the column based on the FE slicer.
A filter of a measure is apply on the table to select only the rows you want.
So the combination of those things returns your result.
Not so simply to do, but i did it!


I hope I have been helpful.
Mark it as a solution if resolve your problem.

Ciao!

jitendracs2004's avatar
jitendracs2004
Frequent Visitor
3 years ago

lucadelicio You are genious. Never thought of this before... Ealier i had to show everything in case no Features are selected and filter only when something gets selected. But i will try to ammend the requirenet to have atleast one selected.

Thanks a ton 

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    thank you for your compliments.
    With two parameter combinated i had never try, but it goes good! 😉
    PowerBI is a brain teaser 😄
    PLEASE MARK IT AS A SOLUTION TO HELP OTHER PEOPLE