Forum Discussion
Conditional Formatting Not Working
Hello all, First off I am new to Power BI so if this is a simple explanation I apoligize. I tried googling and could not really find a solution. I have a table vizualization that I would like...
Anonymous
Yeahh, you have Row with Spaces in that column you need to cleaned before.
One way is create a new Column :
DaysOpennedModified=IF(ISERROR(VALUE('HR'[Days Openned])),BLANK(),'HR'[Days Openned]) , now this column you can change to Whole Number.
Regards
Victor
Hi Anonymous,
I just generated the same exmaple here below
1- Make sure to select Sum from the list based on field
2- No need to set a higher value in the second condition replace 99999 by 100 and replace number by percent
Try it and let me know your feedback
It does not give me the option of sum, only count. How can I change it so I can have sum as an option?