How to Use Measure Names in Parameter Actions
Ғылым және технология
In this week's tip, Lorna shows you how to use measure names in parameter actions. This was part of #WorkoutWednesday2019 Live at TC Europe. Download the workbook on her blog - missdataviz.wordpress.com/201...
Пікірлер: 21
Thank you so much! Many times people ignore these nuanced things.. but so important when you face the actual problem!
Great! Parameter actions was a very needed feature..! Next, we need to use measure name and measure value in a calculated field!
You are freakishly genius . I was struggling with this exact problem for 2 days . Thank you so much
@vizwiz
4 жыл бұрын
Happy to help
The greatest thing is FINALLY we can catch the auto-generated Measure Name and Measure Value in an action. Awesome~
Really helped in our project. Thanks a lot !! :)
@vizwiz
10 ай бұрын
Glad it helped!
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?
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
Thanks a lot!
How to colour dark black at the end for the line chart?
@vizwiz
4 жыл бұрын
satyajit mishra download the workbook
Hi..nice explanation. but selected measure is getting error..is there any specific version related issue?
@sudarsanreddys9060
2 жыл бұрын
Yaa how to crrct it ...?
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.
Is there a reason not to use CASE instead of CONTAINS for the parameter?
Thank you so much!! Would you be kind to explain how the of the percentage value has been built
Nice job