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     🙂

     

     

nandukrishnavs's avatar
nandukrishnavs
Community Champion
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 🙂