Create a barchart with Dynamically Compare the Value of Two Periods

[ronhs]

I follow the step to reappear the measuer from below link.

https://community.powerbi.com/t5/Community-Blog/Dynamically-Compare-the-Value-of-Two-Periods/ba-p/15...

And I want to put the measure into a barchart to realize multiple periods comparison base on day to day.

ex.

period-1   2022/10/31~2022/11/1

period-2.  2021/11/9~2021/11/10

2022/10/31 vs. 2021/11/19

2022/11/1 vs. 2021/11/10

How can I let two period start on those first date, and can be visualize in the mutiple bar chart?

[v-yueyunzh-msft · Accepted solution]

Hi , @ronhs 

Hello This measure is only used to compare sales differences between two date slicers. The x-axis of the bar chart cannot be selected in the same way as a slicer, and placing the measure will fail.

Bar charts are primarily used to show daily trends, and cannot show comparisons of interval dates based on this measure.

If you want to compre the special date period  , you can cretae a table and create another measure to realize it , it cannot be dynamic.

Best Regards,

Aniya Zhang

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