How to Use Measure Names in Parameter Actions

[@eloyeligon6676]

Great! Parameter actions was a very needed feature..! Next, we need to use measure name and measure value in a calculated field!

[@rishabbn4303]

Thank you so much! Many times people ignore these nuanced things.. but so important when you face the actual problem!

[@DrJuanTaco]

Is there a reason not to use CASE instead of CONTAINS for the parameter?

[@tribibpal]

You are freakishly genius . I was struggling with this exact problem for 2 days . Thank you so much

[@vizwiz]

Happy to help

[@shantou]

The greatest thing is FINALLY we can catch the auto-generated Measure Name and Measure Value in an action. Awesome~

[@subhadipmukherjee277]

Thank you so much!! Would you be kind to explain how the of the percentage value has been built

[@sudarsanreddys9060]

when i change the some of profit to selected measure im getting blank sheet on axis only 0 is showing ? only profit ration wrking remaing blank ?plz tell wt do know

[@MrSunitharam]

Hi..nice explanation. but selected measure is getting error..is there any specific version related issue?

[@sudarsanreddys9060]

Yaa how to crrct it ...?

[@johna9214]

Is it possible to choose more than one measure to display in the chart using a parameter? e.g I want to choose both Sales and Profit to display at the same time.

[@vizwiz]

No. Parameters only allow a single value.

[@johna9214]

Thank you @@vizwiz. Is it possible to hide measure names filter on dashboard based on a parameter? I have created multiple views in one dashboard, and I only need it displayed in one of them.

[@vizwiz]

@@johna9214 you can’t show/hide filter cards through parameters nor calcs nor anything else.

[@MrSunitharam]

For me the following formula worked for the 'Selected measure' IF [measure names parameter] = 'Sales' Then SUM([Sales]) ELSEIF [measure names parameter] = 'Profit' THEN SUM([Profit] ELSEIF [measure names parameter] = 'Discount' THEN AVG([Discount]) ELSE [Profit Ratio] END Is there any specific reason or issues if 'Contains' is not used in formula?

[@martinj.a6602]

Really helped in our project. Thanks a lot !! :)

[@vizwiz]

Glad it helped!

[@satyajit8018]

How to colour dark black at the end for the line chart?

[@vizwiz]

satyajit mishra download the workbook

[@JaffetLeon]

Thanks a lot!

[@RJYL]

Nice job