Forum Discussion

JCA's avatar
JCA
Frequent Visitor
2 years ago

Multiple selection bar chart to generate variance calculation

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 2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
JCA
Frequent Visitor
2 years ago

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