Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm working currently with Power BI Desktop using OLAP cubes to load data. After processing the time dimension and presenting it on the graph Power BI automatically assign "Fiscal Calendar..." label to X-axis members on it, which sometimes is simply too long (as shown below). Instead of that I want to use simply "2016" or "FY 2016". And just to add - I don't use formulation Fiscal Calendar anywhere, just Fiscal Year.
Do you know, if it's possible to adjust it?
Hi istolcman,
Are you using import mode or live connection mode?
If you are using import mode, you can simply create a new date column or modify the current data column.
if you are using live connection mode, you can not modify any columns. As a workaround, you can set concatenate on in the format pane(if hirerachy exists) or set Text size smaller to save some space in X-axis.
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |