Forum Discussion

GabrielDC's avatar
GabrielDC
Frequent Visitor
4 years ago
Solved

How to NOT display quarters with no values

Hi All Maybe this is a newbie question but I cannot find the answer anywhere.   We have this chart with the items sold by region, grouped by quarters How can I remove the quarters with no s...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    4 years ago

    Hi , GabrielDC 

    I didn't find a way to hide y-axis = BLANK() in small multiplots, for small multiplots, he is mainly used to clone grouped data showing different categories.And there are limitations for this function:

    For  more information, you can refer to :

    Create small multiples in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

GabrielDC's avatar
GabrielDC
Frequent Visitor
4 years ago

Thanks DataInsights  I does not make any difference:

 

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

GabrielDC,

 

Are you using Small Multiples? This may be the default behavior (not sure if it can be overridden).

 

You can try adding Year to the hierarchy in the X-axis and expand (drill) down to the Quarter level: