Forum Discussion
Helper IIIDynamic values in bar graph based on selection - Daily & Cumulative
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 🙂
3 Replies
- nandukrishnavs
Community Champion
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 🙂 - 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-titles-chart-types/td-p/1027881
v-xuding-msftCommunity Support
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.
