Archives for April 2020

Select slicer,Expand visual filter,and select advance filter and and select is not blank.

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]