cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III

## 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
1 ACCEPTED SOLUTION
Super User

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``````

Appreciate with a kudos
🙂

Regards,
Nandu Krishna

3 REPLIES 3
Community Support

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.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Super User

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``````

Appreciate with a kudos
🙂

Regards,
Nandu Krishna

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors