Archives for April 2020
How to hide Blank in Slicer – Power BI
Select slicer,Expand visual filter,and select advance filter and and select is not blank.

Custom Column, If Statement Power BI
Today I face simple requirement, I need count on Gender, Entered data most of employee did not filed Gender in ERP system. So it is decided we show These records as male.For this I have to edit query and add custom column and update its value with If Condition.
For this I have to edit Query in power BIAdd Custom column with Employee Gender and similar logic.
= if [Gender]= "None" then "Male"
else [Gender]