Multiple selection bar chart to generate variance calculation

[JCA]

Hi All,

I have a set of financial data containing a Month and a Value

Displayed as a Bar chart, Month as my X and Value as my Y

Is it possible for a user to select two months, Say April 2023 to Sept 2023 and generate a variance between the selection in a table with other information?

The goal is to consider paybill growth

I have this working where I can using a slicer select Month 1 and then Month 2, this then generates  a vairance but I would like a slicker user experence than reliance on 2 slicers

Alterntively if I use the slicer to Select Month 1 and then Month 2 could I have a chart display all data between some how?

Thanks

JCA

[v-yaningy-msft]

Hi, @JCA 

May I ask if this is the expected output you are looking for? Based on your description, I have created a measure to achieve the effect you are looking for. Following picture shows the effect of the display.

Measures:

ValueByDate =

VAR _dateStart =

    SELECTEDVALUE ( 'DateStart'[DateStart] )

VAR _dateEnd =

    SELECTEDVALUE ( DateEnd[DateEnd] )

VAR _showInfo =

    CALCULATE (

        SUM ( 'Table'[Value] ),

        'Table'[Date] >= _dateStart

            && 'Table'[Date] <= _dateEnd

    )

RETURN

    _showInfo

If this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[JCA]

HI,

Thanks for the reply!

That's basically the same Dax as I came up with; however, rather than interacting via a pair of slicers for DateStart and DateEnd, I was wondering if it is possible to pick up from a selection off a bar chart?

Or

Generate a Barchart from StartDate to EndDate.

Thanks

JCA