Forum Discussion

pminnov's avatar
pminnov
Helper II
2 years ago
Solved

create space between value and % symbol

Hi, I've created two PBI reports - one in English and one in French. In the French report, I replaced all English text with French and when I published the report and added '&language=fr-ca' to the e...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks solution from danextian 

    Hi, pminnov 

    Based on your description, if you want to add a space between the value and % in the percentage of the data label, you can do this:

    First, I created a measure to find my percentage of sales and put it into the Stacked column chart visual. There is no space between the percentage and the % symbol:

    I used the following DAX to create a percentage of text type spaces:

    Have space percentage = FORMAT([Measure of Percentage],"0.00 %")

    In this case, you need to use the measure of this text type in Format>>Data labels>>Value:

    At this point, it has been discovered that there is already a space between the value and the percentage:

    I've provided the PBIX file used this time below.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

pminnov's avatar
pminnov
Helper II
2 years ago

Wouldn't this change the measure to text (and therefore unable to be displayed in a chart)? The % symbol needs to be displayed for data labels in column charts. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks solution from danextian 

Hi, pminnov 

Based on your description, if you want to add a space between the value and % in the percentage of the data label, you can do this:

First, I created a measure to find my percentage of sales and put it into the Stacked column chart visual. There is no space between the percentage and the % symbol:

I used the following DAX to create a percentage of text type spaces:

Have space percentage = FORMAT([Measure of Percentage],"0.00 %")

In this case, you need to use the measure of this text type in Format>>Data labels>>Value:

At this point, it has been discovered that there is already a space between the value and the percentage:

I've provided the PBIX file used this time below.

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.