Forum Discussion
Counting Buckets
Hi All,
I have the visual below that has the count on the y axis and subject names on the X axis. I am trying to count how many x values have a value of Y.
Example 1 subject Name has a Y value of 8 , 5 subject names have a Y value of 6 , 1 subject name has a value of 5 etc.
Please assist
If I understand correctly, and you want to count categories repeating , then add a measure that counts categories (option 1 on attached pict) or
choose an aggregation on visual itself (option 2 on attached pict)
In other cases, please attach a sample file and a picture showing the desired result.
If I answered your question, please mark my post as solution, Appreciate your Kudos
2 Replies
SB_24 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.If I understand correctly, and you want to count categories repeating , then add a measure that counts categories (option 1 on attached pict) or
choose an aggregation on visual itself (option 2 on attached pict)
In other cases, please attach a sample file and a picture showing the desired result.
If I answered your question, please mark my post as solution, Appreciate your Kudos
