Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I have two columns which sub columns have Blank field ,i do not want to show blank field in the report .how can i do this.
Yet,this problem remains unsolved
Hello @ahadeee ,
You can try applying Sub Location Not Equal to Blank on Page level/report level filtter.
Please mark it as solution if it solves your issue. Kudos are also appreciated.
Still ,i do not understand regarding this problem how to solve it.
If i apply the above filter my primary location also disapperar ,Although i want to remove my sublocation blank field, i want to keep my primary location which do not have any blank field.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 20 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 63 | |
| 56 | |
| 47 | |
| 44 | |
| 37 |