Forum Discussion

georgina261185's avatar
georgina261185
Frequent Visitor
3 years ago

Field Parameter - Filtered value within the Parameter

Hi all   I have a matrix visual that has  Rows = Customer Names Columns =Parameter Values = sales   I want the report user to use the parameter slice to switch between a month view and a year ...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

georgina261185 ,

 

You have switch these two measure like I have done TOPN. You do need separate measures, check the code at the end

 

Assume you have measure m1 , use that for year

 

for month

 

calculate([M1], filter(Table, year(Table[Date]) = year(today()) )

 

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

 

others

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Field Parameters- Conditional Formatting: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

georgina261185's avatar
georgina261185
Frequent Visitor
3 years ago

Hi Amitchandak

 

Thank you for your help. I have tried your solution but I get this error message

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

This is the code i have used - [sell-out Qty] is sales

Switch Sell-Out = switch([Selected parameter],"Mth",calculate([sell-out qty],filter('Posting Date','Posting Date'[Year]=year(today())),[Sell-Out Qty]))