Forum Discussion

BigKev's avatar
BigKev
Icon for Helper III rankHelper III
1 year ago

Discrepencies between visualisation type

Hi All,

 

Something weird appear on my visual.

 

This is what the data looks like when I use table view

However, when I change the visual to Tabular/ Line chart, it seems like the Month Name is shifted -1.

For example, when I hover on July’s bar, it is showing June data (as shown in the tooltip).

 

Hence the last bar chart has not month name, as it supposed to be Nov-24

 

 

There are no complex calculations measure for this, as the number is coming from one table.

I am also using the default PBI visuals and not custom visuals.

 

Does anyone have any idea why this happened? And how to fix the visual chart

 

TIA.

3 Replies

  • Hi BigKev 

    Do you have any filters on the X or Y axis?

    Under the settings in the Visualisation pane.

     

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    very odd, dont suppose you can share your pbix.  

     

    What might help is creating an explicit measure rather than implicit if you haven't 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi BigKev ,

    I can't reproduce your problem with the latest version of Power BI Desktop. What's the version of your Power BI Desktop? How do you set the column chart(Fields settings)? 

    Best Regards