• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

empty bars in power bi visulaisation

grkchakri

New Member
Hi All

Using power bi for visualisation

my data has 3 sales person (a,b,c) are selling diffrent choclate types (c1-c7).
first visualisation is based on sales person and second visualisation is based on choclate type.

Issue is when i am trying to filter by sales person (sales person B) the second visulisation is showing the bars which are empty.
Sales person B sold only choclate types C7,C2, C5
Choclate type C1,C3,C4,C6 are not sold by B is there a way to remove the blanks. I tried to click on the 2nd visualisation graph and use filters option to show choclate type which are not empty or blank but i still see the empty bars

which / what should i use in the filter so that when i click on B i could see choclates sold by B in second visualisation
 

Attachments

  • sample1.xlsx
    14.7 KB · Views: 1
Cannot replicate your issue. suggest you post your file with the chart that is incorrect for analysis and solution.
 
I have attached a screenshot and a brief note. let me know if that helps .

thank you
 

Attachments

  • Screenshot 2024.png
    Screenshot 2024.png
    66.6 KB · Views: 5
Pictures are of no value. Please update the file you have shown with the charts so that we can see exactly how you have formatted your data to create the charts.
 
Back
Top