topic Can see the Continuous or Categorical option when using the Format function in DAX Commands and Tips

Can see the Continuous or Categorical option when using the Format function

Anonymous — Wed, 24 Aug 2022 21:55:18 GMT

Can't see the Continuous or cantegorical Type Option for the X-Axis at the power BI setting when using a column value created using the Format function .

YEAR('DataWarehouse dimDate'[YearStart]) ---- The Type option is available

FORMAT(( 'DataWarehouse dimDate'[MonthStart] ) ,"mmm\ yy") --- The Type option is not avalable

I don't want to see all the data point and don't want to scroll over the X-Axis what is the solution to not sroll left or right on the X axis .

Thank you

Re: Can see the Continuous or Categorical option when using the Format function

amitchandak — Thu, 25 Aug 2022 03:25:45 GMT

Anonymous , Continuous is only available or works for Date and number. It does not work for Text

It can work for yyyymm, not for yyyy \m mm

Re: Can see the Continuous or Categorical option when using the Format function

seanguerrero — Thu, 15 Feb 2024 23:52:05 GMT

How do we make sure it works for YYYYMM?