Forum Discussion
Card visualization for % values
Hi All,
I am new to power BI and am trying to create card visualization to show percentage for a column. Someone suggested that I would need to create a measure first which then I would pull into card. However, my column is a text one.
For example – the problem I am trying to solve for: the column has two values, male and females….so it sums up both, calculates % and then I display only the females in the card. Any ideas on what would work best?
thanks!
Create a measure
Measure = DIVIDE(COUNTROWS(FILTER(Table, Table[Column1] = "female")), COUNTROWS(Table))
Format the measure as a percentage. Put it on a card.
You can't compare a string to a boolean.
Table[Column1] <> ISBLANK(Table[Column1])
If you do an explicit comparison with blank(), you need to understand that 0 and empty string will also be blank.
That's ok if you understand your data.
Best practice is to use ISBLANK, I think you can write
COUNTROWS(FILTER(Table4, not ISBLANK(Table4[Column1])))but please test.
4 Replies
Create a measure
Measure = DIVIDE(COUNTROWS(FILTER(Table, Table[Column1] = "female")), COUNTROWS(Table))
Format the measure as a percentage. Put it on a card.
You can't compare a string to a boolean.
Table[Column1] <> ISBLANK(Table[Column1])
If you do an explicit comparison with blank(), you need to understand that 0 and empty string will also be blank.
That's ok if you understand your data.
Best practice is to use ISBLANK, I think you can write
COUNTROWS(FILTER(Table4, not ISBLANK(Table4[Column1])))but please test.