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

[sayali_deshmukh]

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

[v-xuding-msft]

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. 

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

This might help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

[nandukrishnavs · Accepted solution]

@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 🙂