topic Bar chart 4 years in DAX Commands and Tips

Bar chart 4 years

Mauritius360 — Wed, 30 Aug 2023 13:03:38 GMT

hello,

i have a barchart as per below, when selecting the months from the date slicer, i want the barchart to display the selected months for each year in the barchart. This will allow me to do comparison for same month but all years in the dataset.
for example when selecting the months of Jan/Feb/Mar, the barchart should display years 2021/2022/2023/2024 but the values will be that of Jan/Feb/Mar.

Can you please help ?

thanking you

Re: Bar chart 4 years

Anonymous — Fri, 01 Sep 2023 02:41:05 GMT

Hi Mauritius360 ,

If the field you placed in your slicer is from the same table as the field placed in Visual, you can try the following:

Place [Date] in X-axis as Date Hierarchy, and each year's data will display only the values of these Months as the slicer is selected

If the fields you place in your slicer and the fields placed in Visual are not from the same table and do not have any join relationships, you can try the following:

1. Create measure.

Flag = var _select=SELECTCOLUMNS('Slicer_Table',"Month_number",[Month]) return IF( FORMAT(MAX('Table'[Date]),"mmm")in _select,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

Re: Bar chart 4 years

technolog — Sun, 24 Sep 2023 08:02:27 GMT

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.