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
RielLife
Frequent Visitor

Create slicer based on a measure in measure table

Hi there, 

I am seeking for help asap as a power bi newby. 

I have the following table in a power bi desktop report:

Year-week2018-W27    
NameFTEcontract hourswritten hoursdeltaover time hoursinformation details
John Joe14034-60incomplete hour registration
Dean1400-400all hours are missing
Edward14045,255,250complete without over time registered
Dave14024-164incomplete with over time registered
Emma1404002complete with over time registered
Meghan1404000complete


all columns are measures, stored together in a measure table.
I want to create a slicer visual in my report, so the managers can filter based on the given value in the "information details" column. However, this column is also a measure, which I cannot use as a slicer.

Anyone any clue how I can use the given values as a filter in my report?

2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @RielLife,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @RielLife,

Based on my research, I am afraid that you could not use the measure as slicer currently, please submit an idea in Ideas forum. You may submit a feature request on idea. https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

 

Regards,

Daniel He

 

 

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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