Forum Discussion
Count values in a column
Hello,
I am pretty new to Power BI and I am more used to MS Excel.
I am trying to get Power BI to count the number of times each of these values repeats in each column. Each row represents a survey-taker, but I want to show the total count by requirement (1.1, 1.2, 1.3, etc)
and then I would like to add a visual to show data, something like this:
I was able to do this pretty easily in excel with a composite "countif" formula but I haven't been able to find a way to this in Power BI. Can someone offer some guidance? thanks!
- Anonymous4 years ago
Hi Anonymous ,
Please use unpivot feature in Power Query Editor:
Before:
After:
Create the visual:
Best Regards,
Jay
2 Replies
- amitchandakSuper User
Anonymous , My advice would be to unpivot those columns and post that you can count
https://radacad.com/pivot-and-unpivot-with-power-bi
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. - AnonymousNot applicable
Hi Anonymous ,
Please use unpivot feature in Power Query Editor:
Before:
After:
Create the visual:
Best Regards,
Jay