Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Show all items in X axis

Hi all, I have a line and clustered column chart with week number in the x axis. I've added new data in the last refresh and, although all the data is shown correctly, the x-axis is now showing onl...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Are you using Continuous or Categorical for you X-Axis?

  • Nolock's avatar
    Nolock
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Thanks Greg_Deckler , I didn't know about that :)

     

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Nolock  Greg_Deckler 

       

      Thanks guys. Going for categorical solves the issue but I have quite a lot of charts like that in the file. It'd be quite time-consuming to go chart by chart changing from continuous to categorical. Any idea on how to do that in a faster, more convenient way?

      Many thanks

       

      • Nolock's avatar
        Nolock
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi AlB and Greg_Deckler,

         

        WARNING: the following doesn't work, but it should be mentioned.

         

        All Microsofts modern file formats are zipped files and folders. I've tried to unzip the pbix file and opened the file Report/Layout which is a JSON file. I changed a property (categorial/continuous) of a chart, zipped everything again and voila an error message that the file is corrupted. Then I tried the same once again only with changing a title of a chart. Also didn't work. It means there is probably a fingerprint somewhere in the binaries.

        If it worked you could script it with ease. Unfortunately it doesn't :(

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Found this as had similar issue, thanks for posting and its a Yes from me. Turned a head banging into a thumbs up!!

       

    • amyod's avatar
      amyod
      Frequent Visitor
      3 years ago

      This works...except when you have weeks or months where there is no data. I have no data for September, October, November so my chart skips from month 8 to month 12 which the user might miss unless they look closely. Not help if you're looking for trends at a glance.