Forum Discussion
Slicer
Hi everyone,
Right now, I have a disconnected slicer and i have this measure:
My Disconnected Slicer looks like this:
The table that i have right now is showing this:
Does anyone knows how to make the blank rows to be 1 too? So that when i choose the blank rows, other rows will be 0.
Thank you!
2 Replies
Anonymous , Add additional logic
Switch(True(),
isblank([Certification]) , 1,
containsstring(_chain,_sel),1,
0)
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
hi amitchandak ,
however when i select blank in my slicer, all of the other certificates shows 1 too. likewise when i select CISSP for example, the blank rows showed up as 1 too.
Is this what u meant by add logic?
Thanks
