Forum Discussion
Dynamic 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
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 🙂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
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.
