Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All I have data like below
Period
Q1-Jan
Q1-Feb
Q1-Mar
Q2-Apr
Q2-May
Q2-Jun
Q3-Jul
Q3-Aug
Q3-Sep
Q4-Oct
Q4-Nov
Q4-Dec
i have measure sales
but in chart i need to show only Q1-Jan ,Q2-Apr,Q3-July,Q4Oct
i dont want to show all dimension values in chart any idea
HI @Adinarayana
Try like below
Dim: If(Match(Period, 'Q1-Jan' ,'Q2-Apr','Q3-July','Q4-Oct'), Period)
and uncheck include null values.