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

Problem formatting date field as quarter in formatting field (in column tools)

I need a quarter column chart (continuous chart, not categorical) so i decided to use Start of Quarter (date) field in my chart. It is working fine on chart but can not format date label as YYYY q or YYYY \QQ or YYYY q and any other q tags to show quarter value. It seems there is a problem on using q or Q value to show quarter number on format field.
(Yes i tried a calculated column as "_TEST = FORMAT([Date]; "YYYY \QQ")" it shows the right label but this column can not be displayed as continuous chart, so this is not a solution. )

 

I tried to see the result on PBI Service so i published the report. But poorly result is the same. 

 

ugurdemir_1-1703494441116.png

 

ugurdemir_2-1703494727748.png

 

Power BI desktop Version: 2.124.1052.0 64-bit (December 2023)

 

Status: Investigating

Hi @ugurdemir ,

 

I wasn't able to reproduce your problem. Would you please provide a sample pbix or a detailed reproduction step? (Please be careful not to include sensitive information).

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @ugurdemir ,

 

I wasn't able to reproduce your problem. Would you please provide a sample pbix or a detailed reproduction step? (Please be careful not to include sensitive information).

 

Best regards.
Community Support Team_Caitlyn