Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Same report different visualizations formats between machines


Hi all


I have a power BI report which consumes data from an on premise SSAS multidimensional database using direct query mode. My reports shows the format correctly (percentage, number without decimal for the ranking, etc) but when I share the file with my colleague and he opens the report in a different machine, but with the same configuration (SSAS collate database, language, number format and location in the OS) he can´t view the report as I do. 


We both connect to the same cube but in diferent laptops.


His percentages are in a format like 0,0235468415685478 instead of 2,35 % , his ranking measure is like 2,00 instead of 2. 


It doesn't make sense.


We have checked twice the configuration but we haven't found where is the issue.


Our power bi desktop version is the last one.


Could anyone give me a hand please?.


It is very difficult to work with power BI if we find these strange problems.


Thanks in advanced.




Hi @TailHookPower,


How did you format the percentage value and ranking measure. Please use the format option under Modeling tab as highlighted in below image. 



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Hi Yuliana


Thank you for helping me.


My report consumes data from a SSAS cube using the connection live option so I can´t change the data type because it supposes that it is inheret from the cube.


Please see the picture below



Data format issue.JPG




Hi @TailHookPower,


Are you using Power BI service or Power BI Report Server? How did you share the file with your colleague? Could you please try to publish report to service (if using report server, publish to web portal), then, download to local file on his machine? Besides, let your colleague open the .pbix file with an old desktop version for a test.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Yuliana.


Thanks for your answer.


I connect to the customer´s remote machine login in its web portal. Inside the web portal I download the report to the remote hard drive.


The report show the formats in the wrong way both on one side and the other (web portal and opening the pbix with powerbi desktop).


Then I copy the pbix from the remote machine from my local hard drive and open it.  I change the data source to point to my local cube which is a backup from the remote one.


And here they are, the formats are write, the rankings are correct (1,2,3,etc.. in place of 1,00, etc..) the format porcentages are also write (25,34 %  instead of 0,25341254456).


My parther have the same issues as me in the remote machine and when he download the pbix and open it in his local machine  he don´t see any changes in the format.

What seems intriguing is that he can change the number of decimal in the graphic and after this he is able to see the write format BUT without the percentage symbol.


Everything points to the fact that power bi doesn´t respect the formats that we set up in the cube althought there are other measures that use the percentage format and it shows correctly in the reports.


Lastly and even more disconcerting is that if my partner drags a card visualization to the canvas and he selects one of the measure which fail in the visualization he sees that measure in the write format but not if he select multi-row card visualization.


So, this is what I have ...


Thanks all for your support.



Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Kudoed Authors