cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Furanity Frequent Visitor
Frequent Visitor

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:

 

Image1.png

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:

 

Image2.png

 

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!

6 REPLIES 6
Super User
Super User

Re: Data not shown in visualization

What happens when you click on see data from the visual?



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Furanity Frequent Visitor
Frequent Visitor

Re: Data not shown in visualization

Hi Matt,

 

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

 

Image03.png

Super User
Super User

Re: Data not shown in visualization

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Microsoft v-ljerr-msft
Microsoft

Re: Data not shown in visualization

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.Smiley Happy

 

Regards

Furanity Frequent Visitor
Frequent Visitor

Re: Data not shown in visualization

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 

Microsoft v-ljerr-msft
Microsoft

Re: Data not shown in visualization

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.

 

r1.PNG

 

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

 

Regards

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)