Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I apologize if this has been asked before but I have no previous knowledge of PowerBI and I was just looking for some quick help with what I think(hope) will be a simple solution. I have an Excel sheet that contains collection information. In that Excel sheet there is a text column called "CUSTOMER NAME". I've imported the spreadsheet into PowerBI and chosen this field and a Table vizualization shows all of the values. If I expand the card for filtering I see a list of all of the unique values in the column with a number indicating how many times that value exists in the column. My question is, how do I get those numbers into my data visualization? Basically, I just want some sort of vizualization that counts and displays the number of times each customer appears on the collections list. Thanks in advance for any and all help.
Thanks,
Carl
Solved! Go to Solution.
You need to create a measure using dax like pattern below and drag customer name column the measure to your visual.
Count Num = COUNT ( collections[Customer Name] )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You need to create a measure using dax like pattern below and drag customer name column the measure to your visual.
Count Num = COUNT ( collections[Customer Name] )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |