The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a table in my report with multiple columns. The table is sparse with some columns less than 20% populated. Upon applying a filter on that table, many columns are empty.
How can I hide the empty columns after filtering? Depending on the selection applied on the filter, different columns will be empty.
Can anybody advise?
Thank you.
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |