Line Chart selection Small multiplier issue

[YashikaAgrawal]

Hi, 

In line chart, we have given small multiples
Rows 6
Columns 1
All Padding 12.

Small multiplier - ABC column.

When ALL is selected, its works, but the requirement is "blanks should be removed if 1 selected".

Can this be done.

I tried putting in Filter (is not blank for column ABC)- not working.

Any suggestions please.

Thanks,

[MasonMA · Accepted solution]

Not something Power BI supports natively with small multiples.

The grid layout is fixed once rendered, so even if a selected slicer value returns no data, the visual still reserves that slot..

[YashikaAgrawal]

Thank you for the reply.

[FBergamaschi]

Hi @YashikaAgrawal ,

my suggestion is to work on the DAC code of the measure involved

At the moment are you using a DAX measure with which code?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[YashikaAgrawal]

Thanks for the reply.

X axis -Month

Y-axis- sum(Recordcopunt)
Small multiples  ABC column.

Thanks