Forum Discussion

Pawel_J's avatar
Pawel_J
Frequent Visitor
2 years ago
Solved

Line and stacked column chart – displaying all months when using legend

  Hello,   In my sample data model I have 2 tables. First table contains information about sales, the second table is a date table created using DAX.    I’m currently facing an issue with my lin...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Ritaf1983 , please allow me to provide another insight: 
    Hi  Pawel_J ,

     

    You can click X-axis - [Month Name] - Show items with no data.

     

    Best Regards,

    Liu Yang

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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Pawel_J 
You can add 0 to the measure of bars.
For example (from my sample file) :

Total sales (K/$) = SUMX('orders',('orders'[Unit price]- [Discount])*'orders'[Quantity])+0

The pbix is attached

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