Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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 .

KT1598_0-1661377849353.png

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  
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

How do we make sure it works for YYYYMM?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors