Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

ugurdemir

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

Submitted by Helper II on ‎12-25-2023 01:04 AM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-25-2023 06:31 PM

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

Idea Statuses