The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to use my slicer to show/hide column of my table
table1 (slicer option aswell)
SelectionColumn |
kind |
helpful |
nice |
table2
Name | SelectionColumn | Age | Location | Gift |
nilly | kind | 5 | us | doll |
susan | helpful | 6 | eu | kitchen set |
marcus | kind | 7 | us | bike |
ellen | nice | 8 | jp | books |
I have relationship within the 2 tables.
i want to show the column of :
Name and Gift (from table 2) when I select the nice option from the slicer (from table1),
Gift and Age (from table 2) when I select the kind option fr0m the slicer (from table1),
Name and Location (from table 2) when I select the helpful option from the slicer (from table1),
and when everything is selected from the slicer or no option was choosen, I want everything from the table 2 to be shown in my visual table.
is it possible? what can be our work around for this ?
Consider using field parameters for this.
Also - make sure that is something your users need to get to their insights faster, not just something you want to try for fun.