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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
LinVen
Helper I
Helper I

Slicer to review based on a skill set and a score

Hi All

So, I am trying to work out how i can add a slicer to my report, which would adjust the main visual "Column of weekly staff availability) based upon the staff members "Skills score"


Skills Scores are held in a table, un-pivoted, so person/ID/Attribute/Value (Attribute is the skill type and value is the score)

LinVen_0-1679508840388.png

 

Scores can be 1 to 5

 

So, I want to be able to see the availability based upon the people in the team with a skill level of 4 (or 5) in the field of Energy Management Systems for example.

Tried 2 separate slicers:

LinVen_1-1679509224901.png

 

but the visual does not update....? (The tables of data are linked with clear relationships)



I tried creating a measure too, to calc the average skill score, but that measure will not allow itself to be added to the slicer. (It is a number field)

 

Any help gratefully received

 



1 ACCEPTED SOLUTION

For anyone else with a similar challenge, I think i found it

As this dash will collate information from a few sources, I had used a unique ID column as the main link for relationships

But, by changing from a link back to the Advisory Team Details, to a direct link from Availability Data to Skills, the visuals now behave as I hoped

Corrected Relationship View:

LinVen_2-1679913412200.png

 

(Before, Skills was connected to Team Details using the same ID link as the Team Details to Availability)

View solution in original post

4 REPLIES 4
LinVen
Helper I
Helper I

Hi @amitchandak 

Thank you for your reply. I have watched the videos, but I am still slightly confused and not able to resolve my problem. Your videos focus mostly on Counting based upon a condition, I do not need to count.

 

I have a table of availability (multiple people, per week availability), I need to be able to filter/slicer this to show only the availablity from people who meet the condition of having a certain skill set

The skill set is a large table of Skill Type (Attribute) and Skill Level (Value)


So, I need to be able to say I am looking for availability from people with a skill level of "number" in the field of "Attribute"

 

I get that I could create a Table of potential Skill Levels (0 to 1 , 1 to 2, 2 to 3, 3 to 4 and 4 to 5) but I cannot see how I can relate this back to the slicer behaviour I was looking for

I managed to add a two level Slicer:

LinVen_0-1679912252175.png

  

LinVen_1-1679912267168.png



But, the use of this slicer does not impact visuals. It should only present values for individuals who meet the criteria selected, but it does not, despite teh same ID column being set as the Relationship control between all tables.

 

Anyone have any ideas on what I am missing?

 



For anyone else with a similar challenge, I think i found it

As this dash will collate information from a few sources, I had used a unique ID column as the main link for relationships

But, by changing from a link back to the Advisory Team Details, to a direct link from Availability Data to Skills, the visuals now behave as I hoped

Corrected Relationship View:

LinVen_2-1679913412200.png

 

(Before, Skills was connected to Team Details using the same ID link as the Team Details to Availability)

amitchandak
Super User
Super User

@LinVen < you can not add measure to slicer , for that you need dynamic segmentation

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://youtu.be/EyL7KMw877Q

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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