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) cha...
Need Help
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 

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

        Hi Furanity,

         

        That's a little weird. I just tested it with DirectQuery(on my on-premises SQL via my Gateway too), however, I still can't reproduce this issue.

         

         

        In this scenario, I would suggest you to send a frown and report it as Matt mentioned above.:smileyhappy:

         

        Regards