Forum Discussion
Solved
Show category percent
Hi! I am new at Power BI and I cannot manage to get the percentage of the total in a text category. The thing is that I have data of a given test and there is a column that shows me whether the ques...
Hi oscarmrl,
Try this formula please.
%t Monthv = SUMX ( Table6, IF ( Table6[ok] = "t", 1, 0 ) ) / COUNT ( Table6[ok] )Best Regards,
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi oscarmrl,
Try this formula please.
%t Monthv =
SUMX ( Table6, IF ( Table6[ok] = "t", 1, 0 ) )
/ COUNT ( Table6[ok] )
Best Regards,
Dale
Yes!! Great, now, what should I do if I would like to set the y-axis in a % format?
Now I got 0-1 values but I cannot figure out how to change the format of a measure here.
Thank you very much!
Oscar
- v-jiascu-msft
Hi Oscar,
It's my pleasure. You can try to select the measure and do as the snapshot below shows.
Best Regards,
Dale