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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
xariet
Helper I
Helper I

creating parameter or slicer

Hi All

Is it possible in Power BI to create 2 slices form the data in the following format?

I need a slice to choose Revenue Or Profit and second slicer to choose period: Month, Year, From Inception date

xariet_0-1679535344857.png

thank you 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@xariet , if you want date join to be an option, you can have inactive join with a date table and can activate them using userelationship or use crossfilter non to break the join

 

Check Hire/Terminated

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

For selection, you can use field parameters, if you want to keep 4 measures.

If not you have to create measures using the old measure technique, but you need to check two values (in my example I check only one value)

 

old way

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@xariet , if you want date join to be an option, you can have inactive join with a date table and can activate them using userelationship or use crossfilter non to break the join

 

Check Hire/Terminated

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

For selection, you can use field parameters, if you want to keep 4 measures.

If not you have to create measures using the old measure technique, but you need to check two values (in my example I check only one value)

 

old way

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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