Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Display multiple repeat data values as a count in a visual

Hi,

 

I am quite new to Power BI and am having a real head-scratcher at the moment trying to get a visual to illustrate how may times a list of employees have been given an award.

 

The data-set looks a little like these columns below.

 

Name: Employee ID, Award reasoning / comments / value etc.

Jim     , 1                  ,

Phil    , 2                  ,

Greg  , 3                  ,

Jim     ,1                   ,

etc.

 

On a visual I want to show the count of how many employees have been awarded once, twice, three, etc. times. Help much appreciated!

 

 

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

I would suggest you create a calculated table. One stone two birds.

Table =
SUMMARIZE ( 'Table1', 'Table1'[Name], "times", COUNT ( Table1[Name] ) )

Display_multiple_repeat_data_values_as_a_count_in_a_visual

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

I would suggest you create a calculated table. One stone two birds.

Table =
SUMMARIZE ( 'Table1', 'Table1'[Name], "times", COUNT ( Table1[Name] ) )

Display_multiple_repeat_data_values_as_a_count_in_a_visual

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you!

Greg_Deckler
Super User
Super User

Well, the issue here is your x-axis, you will need to use the disconnected table trick I believe to achieve what you want. 

 

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors