Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to see month and year together as dimensions in the column chart. For example; May 2023 January 2024
try use expression :
Load Month(TempDate) & ' ' & year(TempDate) as MonthYear
from table;
:: TempDate is you date column you want to show as Month Year
I didn't learn writing script. I want to do this in dimension settings for now.
So you can do it also in the dimensions
[Year] & ' ' & [Month]
Thank you i did it. It works but When I set the sorting to "sort by month" it appeared incorrect. Is there any way to fix this?