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: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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