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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.