Forum Discussion
Create a slicer using multiple columns of a table - NOT NESTED
Upload it on wetransfer it is free.
https://wetransfer.com/
Thank you
- lucadelicio3 years ago
Impactful Individual
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!
- jitendracs20043 years agoFrequent Visitor
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
- lucadelicio3 years ago
Impactful Individual
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
- ljx06482 years ago
Helper III
Hi Luca,
By any chance you still have the PBI file for the solution of this matter?
I have a similar question and would much appreicated your help!
I tried to click the link to download the PBI in the link you provided but its expired.
Thank you!
- cswien9410 months agoNew Member
Do you still have this solution? I have the same issue.