Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have an on-premise tabular model with a fact/date table. The date table has a Year column displaying years as 2014, 2015.
When I create a line chart on Power BI.com and add the Year column from the date table to the Legend it displays as 2,014.0
How can I change the legend formatting with the Power BI service?
Solved! Go to Solution.
Hi
I solved this problem. A little background. The field was a calculated field (tabular) for FiscalYear. In Tabular and SSMS the appearance of the number was fine. In Power BI Desktop & Service the number changed to 2,015.00. The reason is because in Tabular the property of the columns for Data Format was Auto. I suppose Power BI is trying to be helpful. When I set the format to Whole Number and redeployed the problem went way.
Thanks for your help.
@Anonymous The type of axis is Continious your have change it to Categorial to get Year values.
Step By Step:
1. Select the chart which is showing Continious values for years
2. In the right pane go to Format tab
3. Open the axis which has Years suppose it is X-axis
Change the property Type from Continious to Categorial
Cheers
Harris
This doesn't work. In any case the Year is on the Legend (series) rather than the X Axis.
@Anonymous Can you please share a screen shot
Hi
I solved this problem. A little background. The field was a calculated field (tabular) for FiscalYear. In Tabular and SSMS the appearance of the number was fine. In Power BI Desktop & Service the number changed to 2,015.00. The reason is because in Tabular the property of the columns for Data Format was Auto. I suppose Power BI is trying to be helpful. When I set the format to Whole Number and redeployed the problem went way.
Thanks for your help.
@Anonymous Good that you found the solution. Please mark the post as answered so others can benfit from it.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
96 | |
46 | |
25 | |
20 | |
19 |