Solved: Clustered Column Chart - Static X-axis with slicer - Page 2

Anonymous · ‎05-22-2019

I have a Clustered Column Chart for TYPE in X axis and Avarage Sales price per SQM

as Follows

As u see there are 5 TYPES and there is a CITY slicer on the right.

if i change the CITY the chart will change as follows

Because the above selected CITY only have info for the 3 CATEGORIES its changing the visual to display only 3 CATEGORIES instead of 5.

i want to keep all the 5 CATEGORIES when i select CITY, even if there is no information, it can show it as 0

how can i do that.

appreciate your help

Anonymous · ‎05-22-2019

@Anonymous - Here are 2 ways to do that:

1. Create a Measure like this:

Measure =
<Whatever calculation> + 0

2. In the visual, select "Show Items with No Data":

Hope this helps,

Nathan

Clustered Column Chart - Static X-axis with slicer