Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Would appreciate some help on this please.
I have a lot of data set up already. The below output is a table and filtered by 'Year/Month' and 'Name' of the person.
Four different Tables (Tickets Worked,Ticket Updates,Phone Calls and Incident Reviews)
The table totals will change based on the person i select in a name slicer and the months i select.
The Last 6 Month totals in green are just total counts of the selected months added up and displayed in a Card widget, however Incident Reviews is an average instead of count.
What I now need to do is assign KPI levels to the 6 Month Totals
KPI Levels
Level 0
Level 1
Level 2
Level 3
These Levels are determined based on More than and Less than. Each Table has a different criteria range of numbers.
Example for Ticket Updates
Once I have a KPI Level for each, I need to get the average of the 4 results out of "3". I.E Level (1+2+1+3)/4 = 1.75
This is kind of how i want it to look to give you an idea what im trying top acheive.
I just dont know how to get these levels based on the data.
Part of the issue is that the table data isnt by year/month.
I thought i could add a column to get the count of rows for a given person for the given month and then use that number to apply criteria to and get a level from it. But as there are rows for many days in the month, each row gets given a value and then the table sums all the rows for the month giving me the correct number but X30 days.
example of data set for tickets updates. some data greyed out
Thanks
@Epidot , I think you need segmentation on measure
few examples
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
Thank you i will take a look at these.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |