The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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
Thanks for your input.
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!!
Thanks for sharing ideas. I didn't use anu measure so far. Can use share measure to achieve below screen
Thanks for sharing ideas. I didn't use any measure so far. Can you please share the measure to achieve below screen
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
Thanks for your input.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |