ytd column to bar chart

k_peter — Wed, 26 Jul 2023 08:45:38 GMT

I want to add my bar charts a YTD column.

I have created a date table with all the month and a 13. as YTD.

Connected it to my data table. many to one relationship

For the bar chart I have created a measure.

Sol prep w YTD =

VAR Oldatkeszites_YTD =

CALCULATE(AVERAGE('Report 2'[Oldatkészítés]),all('Month YTD Old'[Month]))

return

VAR Oldatkeszites =

AVERAGE('Report 2'[Oldatkészítés])

return

switch(SELECTEDVALUE('Month YTD Old'[Month]),"YTD",Oldatkeszites_YTD, Oldatkeszites)

As the month names with the ytd are in text format i needed to sort the axis by the month number where the ytd is the 13. It was ok. But after I have tried to do the same with box and whisper chart as well at that case the axis sort by monthno is not working. So I sorted the month by the month no directly in the table. After that the ytd datas dissapeared from my bar charts as wll.

What could be the problem_? any idea?

topic ytd column to bar chart in DAX Commands and Tips

ytd column to bar chart