locked
Change data labels in Power BI Reports RRS feed

  • Question

  • How do I change the format of the numeric data in the vertical/horizontal axis of a power BI report? Any help will be highly appreciated ....

    Thanks,

    Tuesday, June 16, 2015 11:14 PM

Answers

  • Hi Bhaskardeb.....I understand that you are looking to change the data type / format of a measure / field in a PowerBI report / chart.

    You will have to change the data type of the underlying field in order for this change to flow to the report / chart.  Please see the following article for how to change in Power BI Designer:  https://support.powerbi.com/knowledgebase/articles/558030-data-types-in-power-bi-designer.

    If you are using Excel Power Pivot for development, please see the following article for a column that would apply as well to a calculated field in the calculations area of the Power Pivot model:  https://support.office.com/en-nz/article/Set-the-data-type-of-a-column-in-Power-Pivot-e62c582e-824f-439a-8437-680534100e11?ui=en-US&rs=en-NZ&ad=NZ

    or this screenshot of the calculated field within Excel:


    PowerDAX.com

    Wednesday, June 17, 2015 3:49 PM
  • Hi Bhaskardeb.....I understand that you are looking to change the data type / format of a measure / field in a PowerBI report / chart.

    You will have to change the data type of the underlying field in order for this change to flow to the report / chart.  Please see the following article for how to change in Power BI Designer:  https://support.powerbi.com/knowledgebase/articles/558030-data-types-in-power-bi-designer.

    If you are using Excel Power Pivot for development, please see the following article for a column that would apply as well to a calculated field in the calculations area of the Power Pivot model:  https://support.office.com/en-nz/article/Set-the-data-type-of-a-column-in-Power-Pivot-e62c582e-824f-439a-8437-680534100e11?ui=en-US&rs=en-NZ&ad=NZ

    or this screenshot of the calculated field within Excel:


    PowerDAX.com

    Following on from what PowerDAX has mentioned, when using the Power BI Designer you can format the data labels on an axis by using the Modeling tab and changing the format of corresponding column/measure. 

    In the below chart we want to simply format the axis with the quantity (i.e. y axis) to show numbers with the thousand separator:

    If we select the column/measure in the Fields pane, the Modeling tab should become visible (if it wasn't already). We can then use the Formatting area on this tab to format the column/measure as desired. In this case we are simply adding the thousand separator:



    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Thursday, June 18, 2015 10:37 PM
    Moderator

All replies

  • Hi Bhaskardeb.....I understand that you are looking to change the data type / format of a measure / field in a PowerBI report / chart.

    You will have to change the data type of the underlying field in order for this change to flow to the report / chart.  Please see the following article for how to change in Power BI Designer:  https://support.powerbi.com/knowledgebase/articles/558030-data-types-in-power-bi-designer.

    If you are using Excel Power Pivot for development, please see the following article for a column that would apply as well to a calculated field in the calculations area of the Power Pivot model:  https://support.office.com/en-nz/article/Set-the-data-type-of-a-column-in-Power-Pivot-e62c582e-824f-439a-8437-680534100e11?ui=en-US&rs=en-NZ&ad=NZ

    or this screenshot of the calculated field within Excel:


    PowerDAX.com

    Wednesday, June 17, 2015 3:49 PM
  • Hi Bhaskardeb.....I understand that you are looking to change the data type / format of a measure / field in a PowerBI report / chart.

    You will have to change the data type of the underlying field in order for this change to flow to the report / chart.  Please see the following article for how to change in Power BI Designer:  https://support.powerbi.com/knowledgebase/articles/558030-data-types-in-power-bi-designer.

    If you are using Excel Power Pivot for development, please see the following article for a column that would apply as well to a calculated field in the calculations area of the Power Pivot model:  https://support.office.com/en-nz/article/Set-the-data-type-of-a-column-in-Power-Pivot-e62c582e-824f-439a-8437-680534100e11?ui=en-US&rs=en-NZ&ad=NZ

    or this screenshot of the calculated field within Excel:


    PowerDAX.com

    Following on from what PowerDAX has mentioned, when using the Power BI Designer you can format the data labels on an axis by using the Modeling tab and changing the format of corresponding column/measure. 

    In the below chart we want to simply format the axis with the quantity (i.e. y axis) to show numbers with the thousand separator:

    If we select the column/measure in the Fields pane, the Modeling tab should become visible (if it wasn't already). We can then use the Formatting area on this tab to format the column/measure as desired. In this case we are simply adding the thousand separator:



    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Thursday, June 18, 2015 10:37 PM
    Moderator