Display required columns in tables based on slicer selection.

[Jayasimman]

Hi all,

I would like to see columns, which has value in the rows based on selected value in slicer.

Example: Slicer and Table1  

If i click on "Z" in the slicer,then table1 need to show only columns of E,D and RT 

Empty colums of S,M,SS to be hided.

How we can implement this in powerbi? Please support.

 

[Jayasimman]

Thanks for your input.

[Kishore_KVN]

Hello @Jayasimman ,

If you are using any measure then please share it to look at it. If not create matrix visual directly and it can filter data as you required. Look at below screenshot:

Below visual is not interacting with slicer and above visual is interacting where for 'Z' you can see the output reflect same as 'D','E' and 'RT'

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Jayasimman]

Thanks for sharing ideas. I didn't use anu measure so far. Can use share measure to achieve below screen

[Jayasimman]

Thanks for sharing ideas. I didn't use any measure so far. Can you please share the measure to achieve below screen

[Ritaf1983 · Accepted solution]

Hi @Jayasimman 
There is no way to hide blank columns in the table.

consider using a matrix with putting category (e,s,m, etc... ) as a column.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Jayasimman]

Thanks for your input.