Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
1 year ago

Published Power Bi Visual Column Chart randomly loses multiple X-Axis

I have a dashboard with 9 clustered column charts and ocasionally one will lose its sorting and two level X-Axis?.     

 

Why does this happen?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi bdehning ,

     

    I want to make sure that this happens occasionally and that only one visual has this problem.

     

    I ran a simple test based on your description, is my procedure the same as yours?

    1.Use sample data in Power BI desktop:

    2.Create multiple clustered column charts:

    3.Set the sorting for each bar chart:

    4.Publish to Power BI Service, open the report and pin to a dashboard:

    5.It worked in the end.

     

    You can try to troubleshoot if there is an error when setting up the bar chart, refreshing the visuals, and if you can specifically describe the steps to reproduce the problem you are having, providing a detailed description of these steps will help in diagnosing and resolving the issue more efficiently.

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

     

     

     

    • bdehning's avatar
      bdehning
      Post Prodigy
      1 year ago

      Start by using two Columns in X Axis like 

      I can provide more specifics later as I use a Filter for Top 3 of Count which is for Cause and Sort Measures to provide Top 3 of Tenure.   

      I have set up Slicer Page so users can select what ever company that want and they can select from 1 to all years the company has been a customer.  

       

      I can test many companies and all 9 visuals perform just perfect.  I can select others and if I use two years they may work, but if only select one year, 2 visuals may lose the sort.   See example below.  This is one year of data selected.  

       

       

      Here is two years of data

      Works as intended.  

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi bdehning  , 

        As shown, have you tried sorting based on other columns:

         

        For the problem of sorting lost can create an index column, according to the actual situation, select a column according to the index column sorting, the following is a simple test:

         

        1.Here is the simple data, here an index column is created, note that the index column must maintain a one-to-one relationship with the field that needs to be sorted, otherwise an error will be reported:

         

         

        2.Select the year column and sort by the index column.

         

         

        3.You can see the difference in the two pictures below, the first one is not sorted and the second one is sorted:

         

        Link on sorting by columns can be found here:

        Sort one column by another column in Power BI - Power BI | Microsoft Learn

         

        You can adjust the sorting logic to suit your reality, and if the problem persists, providing a PBIX file that is removed the sensitive data will allow the problem to be localized and resolved more quickly!

        You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set up public access), SharePoint, or a Github repository, and then share the URL of the file.

         

        Best Regards,
        Zhu
        Community Support Team

         

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