cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rode
Advocate II
Advocate II

[BUG] Bar chart: show values with no data

Hi everyone,

I have the last release of Power BI Desktop. On a report I am working on I have a problem with bar charts.

On the x axes there are four countries, on the y axes there are some KPIs. Also if I select the option "show values with no data" on the x axes configuration, the chart shows only less countries when I filter something.

But if I create a new bar chart with the same configuration of the previous one the problem is solved. It seems to be a bug.

I ask to Microsoft to figure out what's the problem inside this situation.

 

Thank you,

Regards.

 

1 ACCEPTED SOLUTION

Hi @rode,

 

As you said, this problem occurs to some older reports where you created chart before, and now, this problem has disappeared. I think it looks like an issue before, but it might has been fixed by product team now. If you still have any concern about this problem, you could report an issue or create a support ticket here.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-yulgu-msft
Microsoft
Microsoft

Hi @rode,

 

What did you mean "the chart shows only less countries when I filter something"? What filter did you apply? In my test, I didn't encounter any problem with bar chart. Does this problem persist now when creating such a bar chart in your Power BI desktop?

 

By the way, have you ever created a support ticket? If you get any useful reponse about this problem, appreciate for your sharing.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft and thank you for your answer.

 

When I say "the cart shows only less countries when I filter something" I mean a situation like the following:

- Consider to have 4 countries on X axes of the bar chart and the slicers do not filter anything

- Now let's use some slicer and, for example, filter out some customers: suppose that the chosen customers are not present in one country. So, only 3countries are shown instead of 4. Here comes the problem!

 

Even though I change the configuration of the bar chart and select "Show values with no data" on the contry (X axes), the bar chart keeps on showing 3 customers. The only way to solve this problem is to create from the scartch a new bar chart identical to the previous one.

 

By the way, I've never createda support ticket. Do you think is this one the case? As I said, it seems to be a bug.

 

Thanks a lot!

Regards.

Hi @rode,

 

This is not a bug. By default, column headings are only displayed in your reports if they contain data. That is to say, in your table, there existing one row that contains Counrty4 and its corresponding custom is empty (blank value). In that case, to display empty categories, click on the down-arrow in the field you want to change in the Visualizations pane, and select Show items with no data. However, if there is no such an empty row data, it is not possible to show Country4 if filtering by customers not present in this country.

 

To work around your requirement, please refer to below steps.

 

Source data view.

1.PNG

 

Create a new calculated table.

Table1 = ADDCOLUMNS( CROSSJOIN(VALUES(Sheet1[Country]),VALUES(Sheet1[Custom])),"Amount",BLANK())

2.PNG

 

Based on table1, create another table.

Table2 = SUMMARIZE(UNION(Sheet1,Table1),Sheet1[Country],Sheet1[Custom],"Amount",LOOKUPVALUE(Sheet1[Amount],Sheet1[Country],[Country],Sheet1[Custom],[Custom]))

3.PNG

 

Add a chart visual and slicer, then, drag fields from table2.

4.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft and thank you so much for the answer!

 

Do you mean that if in CountryB I don't have a row that associates it to Customer3 (i.e. without tha last row in the last table you've shown) "Show items with no data" feature doesn't work?

 

I'm so confused. My situation is like this one I've just descripted: there are some countries in which certain customers are not present. So, by using the same bar chart I created some months ago it doesn't work. But if I create a new bar chart identical to the first one the problem is not present anymore! This is the reason for which I think that it's a bug (substantially, "Shown items with no data" option is activated on both the chart and their configurations are the same: the first doesn't show all countries but the second one does).

 

Thank you again!

Regards.

 

 

Hi @rode,

 

Do you mean that if in CountryB I don't have a row that associates it to Customer3 (i.e. without tha last row in the last table you've shown) "Show items with no data" feature doesn't work?

 

Yes. So, even in that case, those countries in which certain customers are not present are invisible after selecting a custom in slicer, right?

 

Now, does this issue persist in your scenario? What is your desktop version? Currently, the latest release is 2.47.4766.542, have you updated to the latest one?

 

Regards,
Yuliana Gu 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


[rode]

Do you mean that if in CountryB I don't have a row that associates it to Customer3 (i.e. without tha last row in the last table you've shown) "Show items with no data" feature doesn't work?

 

[v-yulgu-msft]

Yes. So, even in that case, those countries in which certain customers are not present are invisible after selecting a custom in slicer, right?


 Yes, your sentence was right for the first bar chart I was talking about in my previous message. But in the second one the problem automatically fixed, so those countries are shown without data (that's the proper effect I want).

[v-yulgu-msft]

Now, does this issue persist in your scenario? What is your desktop version? Currently, the latest release is 2.47.4766.542, have you updated to the latest one?

 


As I've written before, the problem doesn't persist because I've replaced the bar chart with the new one (with the same configuration) in which the problem does not come up.

 

Anyway, I've just found an older version of my report in which the first istance of the bar chart is used. I've flagged "Show item with no data" option and the problem persists. Again, if I create the same bar chart from the scratch, the problem seeems to disappear in it.

 

I'm using Power BI Desktop 2.47.4766.542 (latest release).

Do you think is it the case to open a ticket?

 

Thank you!

Regards.

Hi @rode,

 

As you said, this problem occurs to some older reports where you created chart before, and now, this problem has disappeared. I think it looks like an issue before, but it might has been fixed by product team now. If you still have any concern about this problem, you could report an issue or create a support ticket here.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors