Forum Discussion

TailHookPower's avatar
TailHookPower
Frequent Visitor
8 years ago

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...
formats
Issue
Reports
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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. 

 

Regards,
Yuliana Gu

TailHookPower's avatar
TailHookPower
Frequent Visitor
8 years ago

 

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

 

 

 

 

Regards

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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.

     

    Regards,

    Yuliana Gu

    • TailHookPower's avatar
      TailHookPower
      Frequent Visitor
      8 years ago


      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.

       

      Regards.