Forum Discussion

sayali_deshmukh's avatar
sayali_deshmukh
Helper III
6 years ago
Solved

Dynamic values in bar graph based on selection - Daily & Cumulative

I have table with separate columns for Daily and Cumulative values Need help for creating a bar graph to show Daily or Cumulative values according to selection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    sayali_deshmukh 

     

    Define one table with a selection values

    example 

    SelectionTable

    Item
    Daily
    Cumulative

     

    Then switch your column/measure based on the slicer selection.

    Try something similar to below.

     

     

    Measure =
VAR _item =
    SELECTEDVALUE ( SelectionTable[Item] )
VAR result =
    SWITCH (
        TRUE (),
        _item = "Daily", SUM ( 'Table'[DailyValue] ),
        _item = "Cumulative", SUM ( 'Table'[CumulativeValue] )
    )
RETURN
    result

     

     

     



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

     

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi sayali_deshmukh ,

 

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as solution. You could share your own solutions as well. More people who encounter the same issue will benefit from here. If you are still confused about it, please some sample data and the expected result to us.