Forum Discussion

jason_hill's avatar
jason_hill
Advocate I
9 years ago

Pie Chart Colours Keep Changing

We have created a number of dashboards and have pinned live pages for each of the tab from the report. When you first open Power BI, each pie chart is formatted with the standard colour palette. Howe...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi jason_hill,

 

The attached .PBIX file is created in Power BI Desktop version 2.39.4526.362. Please update the desktop to this latest version then create pie chart use Azure SQL database to see if issue persists.

 

Best Regards,
Qiuyun Yu

jason_hill's avatar
jason_hill
Advocate I
9 years ago

Here's the steps I performed:

 

  • Updated to the latest BI desktop
  • Created a completely new PBIX with a simple pie chart pulling data from Azure via DirectQuery
  • Copied the PBIX and just changed the connection to a different Azure database
  • Published those PBIX files to two different workspace groups within the BI service
  • Pinned the live page for each report into new dashboards
  • Open the BI service and opened the first new dashboard - the pie chart colours are fine
  • Switched to the other new dashboard and the pie chart colours are a bit whack. Refreshed the page and the colours are fine.

So, yes the problem still occurs with the latest BI desktop and creating a new PBIX with a really simple pie chart.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi jason_hill,

     

    I notice you copy the .PBIX, please pin the live page for the original report to see if issue occurs.

     

    Also can you open the original .PBIX file and save as different .PBIX file to duplicate the report? Then publish these reports to service and pin live page to see if color changes?

     

    Best Regards,
    Qiuyun Yu

    • jason_hill's avatar
      jason_hill
      Advocate I
      9 years ago

      The colours are fine when pinning a live page from the same report to different dashboards.

       

      I then used the save as method to duplicate the report and published those to the service and pinned live pages to different dashboards. The colours are fine for the first dashboard but after switching to the second dashboard, the colours go wrong again.

       

      It deosn't matter which order you open the dashboards either...the first one displays OK but the colours go wrong with the second dashboard.

      • elliotdixon's avatar
        elliotdixon
        Responsive Resident
        9 years ago

        I have the same issue with colours. Have tried removing the pbix file and creating it again all to no avail.

        Would be great if the colours match all the way through but at the moment I seem to have no ability to lock this down.

         

        desktop

        website

        iphone