Help needed - Complex Data VIsualization

[AleksandrMe]

Good day, 

I'm struggling to get result I need in my data/visualization. 

I have 15 objects. In every object I perform inspection using 10 categories. Every gategory has 3 answers: GOOD/AVERAGE/BAD. 

No I need to create Data showing per per category (10 in total) how many objects are bad, good and average. 

Whatever I try, doesnt work. Any ideas? 

Thanks

Alex 

[luapdoniv]

Hi Alex,
Not sure if this is what you are trying to achieve:

[MFelix · Accepted solution]

Hi @AleksandrMe ,

Try to create a stacked column chart with the following setup:

• Axis - Categories
• Legend  -Answers
• Values - Count of Objects

Can be one possibility.

[AleksandrMe]

Thanks, This actually works in some way for me. 

Additional Question: Every object has at least one "GOOD" in answers. But onle 2 objects have "BAD". 

If I whant to use slicer - selection "GOOD" works great and still shows me all categories and % of total objects Catgories. 

However if yo choose slicer to show BAD, it will filter it and will only show me categories where "BAD" was answered, total % is not correct then. 

Is there any chance to amend slicer that way that categories are not filtered out but only values? 

THnaks