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

  • @rishabbn4303
    @rishabbn43033 жыл бұрын

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

  • @eloyeligon6676
    @eloyeligon66765 жыл бұрын

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

  • @tribibpal
    @tribibpal4 жыл бұрын

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

  • @vizwiz

    @vizwiz

    4 жыл бұрын

    Happy to help

  • @shantou
    @shantou5 жыл бұрын

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

  • @martinj.a6602
    @martinj.a660210 ай бұрын

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

  • @vizwiz

    @vizwiz

    10 ай бұрын

    Glad it helped!

  • @MrSunitharam
    @MrSunitharam4 жыл бұрын

    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?

  • @sudarsanreddys9060
    @sudarsanreddys90602 жыл бұрын

    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

  • @JaffetLeon
    @JaffetLeon2 жыл бұрын

    Thanks a lot!

  • @satyajit8018
    @satyajit80184 жыл бұрын

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

  • @vizwiz

    @vizwiz

    4 жыл бұрын

    satyajit mishra download the workbook

  • @MrSunitharam
    @MrSunitharam4 жыл бұрын

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

  • @sudarsanreddys9060

    @sudarsanreddys9060

    2 жыл бұрын

    Yaa how to crrct it ...?

  • @johna9214
    @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

    @vizwiz

    Жыл бұрын

    No. Parameters only allow a single value.

  • @johna9214

    @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

    @vizwiz

    Жыл бұрын

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

  • @DrJuanTaco
    @DrJuanTaco5 жыл бұрын

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

  • @subhadipmukherjee277
    @subhadipmukherjee2775 жыл бұрын

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

  • @RJYL
    @RJYL5 жыл бұрын

    Nice job

Келесі