Forum Discussion

Furanity's avatar
Furanity
Helper I
9 years ago

Data not shown in visualization

Hi all,

 

I have a strange issue that I can't seem to figure out. Please see the following Image:

 

As you can see, I have a slicer. Based on the option I choose, the (clustered column) chart on the top-right is presented. If I click/select the black option in the visualization, you can see how it splits up in the bottom table visualization. So far so good.

 

Now, if I change the table visualization to a clustered column visualization (and nothing else), I get this:

 

 

So, as you can see, values just drop out of the visualization. The yellow section should be around 3300, but it just shows zero. I have the same issue with other graphical visualizations (Pie chart, Funnel, for example). The tables work, the Area Chart works, so it's not like the data isn't there.

 

Any suggestions on what might be wrong? Is there some kind of bug, or is it me?

 

Thanks!

Need Help

6 Replies

  • Furanity's avatar
    Furanity
    Helper I
    9 years ago

    Hi Matt,

     

    If I show the data, the number is there, but it's not visualized (3446 in the data, 0 in the chart):

     

    • MattAllington's avatar
      MattAllington
      Community Champion
      9 years ago

      Well it seems like a bug then I guess. You can send a frown and report it

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi Furanity,

       

      According to your description, I have tested it on my side, and I can't reproduce this issue. Could you share a sample pbix file which can reproduce this issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

       

      Regards

      • Furanity's avatar
        Furanity
        Helper I
        9 years ago

        Hi,

         

        I'm not sure how I can share my PBIX, since I use DirectQuery (on an on premises SQL via my Gateway) and not an import. I can't share my report, since you're outside my organization and sending you the PBIX would probably not work.

        If I use Import Mode by the way, the numbers do add up, so it seems to be tied to the DIrectQuery Mode.

         

        Regards