Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Graph X-Axis looks different on Services compared to Desktop

Hi Guru's 

 

I have an issue with a graph/axis on the graph I dowloaded from Power BI visuals market place. The graph is called "Bullet graph from OKviz"

When I make the bullet graph on the left in Power BI desktop it looks like this:

 

But when I upload it to Power BI Services, it looks like this:


 

 

 

 

 

 

 

  1. I dont want the day of the week to display, and
  2. I am not interested in it showing thw 1st of each month.

Any help would be greatly appreciated.

 

Kind Regards 

 

Jason 

  • Hi Anonymous ,

     

    In Power BI Desktop, you may click on your Date column in Field pane, then go to Modeling ->Date type, set the Data type like following picture, then republish it again. Or you may download this .pbix from Power BI Service, open it in Power BI Desktop to set the Data type of Date column.

     

    Best Regards,

    Amy

     

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

2 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    In Power BI Desktop, you may click on your Date column in Field pane, then go to Modeling ->Date type, set the Data type like following picture, then republish it again. Or you may download this .pbix from Power BI Service, open it in Power BI Desktop to set the Data type of Date column.

     

    Best Regards,

    Amy

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-xicai ,Amy

       

      Thank you for the assistance, this worked like a charm.

       

      Kind Regards

       

      Jason