Clustered Column Chart - Static X-axis with slicer

[Anonymous]

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]

Thanks Natel, issue resolved with adding ur suggested measure.

[Anonymous · Accepted solution]

@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

[Anonymous]

Hello @Anonymous 

Thank you for your reply. i tried the second method "Show items with no data" 

its working on some visuals and some not.

any idea why would this happen??????

[Anonymous]

@Anonymous - One way it can happen is when values from 2 attributes in the same table don't intersect. In that case, you may want to have them in separate tables.

Do you want to share some examples of the model relationships and visual results? Or your pbix?

Cheers,

Nathan

[Anonymous]

pbix is really large and confidential. so i will give you screen shot of the relaitonship. let me know if its not enough so we workout something else.

image removed, refer to image in questions

or i can give you remote access to dataset if you want

Thank you again for your help

[Anonymous]

@Anonymous  - What tables/fields are involved in the chart(s) that aren't working? Also, please share a screenshot of the chart(s).

[Anonymous]

 made 2 same charts on 2 diffrent pages. 

after applying your suggetion (Show items with no data) thats what i get

Page 1:

your suggestion is working on page 1 here are 2 screen shots before and after applying slicer:

WITHOUT filter applied 

image removed, refer to image in question

WITH filter applied

image removed, refer to image in questions

you see above everything is working fine.

Now

Page 2

WITHOUT filter applied 

image removed, refer to image in question

WITH filter applied

image removed, refer to image in question

[Anonymous]

What are the tables/fields used in the different charts, and in the slicer?

[Anonymous]

the data is 

real eastate price(yaxis)            -         type of property (xaxis)             Date

80                                                        villa                                             mmddyyyy

90                                                        house

20                                                        land

the filter is YEAR WITH QUARTER

[Anonymous]

So they're using the same fields in the chart? And th slicer - does it come from different tables on the 2 pages?

[Anonymous]

yes coming from same table. 

[Anonymous]

realestate price                     Type of property               date

50                                          villa                                    ddmmyy

80                                           house                                ddmmyy

90                                          land                                    ddmmyy

the slicer is date

The 

the 

etc