Forum Discussion
vividarinda
Helper II
Helper IIHow to Show Value Null If Filter Selected
Hi Guys,
I have one dataset ,like this
| UnitNo | Model | Category | Count | Location |
| 16DT0912 | 777D | Petrosea | 1 | KJA |
| xxx | 777D | 0 | KJA | |
| 77DT0123 | 777D | KBL | 1 | KJA |
| 16DT0567 | 777D | Petrosea | 1 | KJA |
| 16DT9123 | 777D | Rental | 1 | KJA |
| 16DT9341 | 777D | Rental | 1 | KJA |
in my visualization Power BI report there is a slicer for which I've captured the selections using below category.
But when i click one category, the visualization show like this, there is a lot off unfilled data.
Let me know how this could be accomplished using DAX query.
2 Replies
- VijayP
Community Champion
vividarinda From your question , I have understood taht you want "null" in the blank cell?
DAX - if(isblank(measure),"null", measure)
vividarindaVijayP ,
Thanks vijay for your feedback.
My expectation the visualization after i click category slicer, then the table show 0. Like this.
