Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Clustered Bar chart with individual reference line

Hello, I've been trying to create a clustered bar chart with a reference line for each column bar, something like the image below.  Does anybody knows if it is possible? The reference line is the va...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

To use the previous months value, you can create a meausre like this to calculate and use a month as a slicer:

Measure =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Date].[MonthNo]
            = SELECTEDVALUE ( 'Table'[Date].[MonthNo] ) - 2   //this calculate two months ago value,depends on the acutal need
            && 'Table'[Category] IN DISTINCT ( 'Table'[Category] )
    )
)

Enable the Stepped option under the Shape menu, change the measure color to white under Data colors menu, diable the legend option, the result would be like this:

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.