Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Plot zero when there is no data in line chart solution affects the date filter

Hi,   I have almost the same issue as descibed here:   https://community.powerbi.com/t5/Desktop/Plot-zero-when-there-is-no-data-in-line-chart/td-p/506235 https://community.powerbi.com/t5/Desktop/...
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    Your data is not continuous, and the date column has a specific time.

    So you need to create a column and an additional date table,then use that date in slicer.

    Like this:

    Column = DATE(YEAR([CreatedDate]),MONTH([CreatedDate]),DAY([CreatedDate]))
Table = CALENDAR(MIN(testdataPowerBIcsv[CreatedDate]),MAX(testdataPowerBIcsv[CreatedDate]))

    Here is my sample .pbix file.Hope it helps.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

Try like this:

column:Year Month = format([Date],"mmm yyyy")

measure :=
CALCULATE (
COUNTX ( 'Cases', 'Cases'[CaseNumber] ),
ALLEXCEPT ( 'Cases', 'Cases'[YearMonth] )
)+0

Could you mind providing some sample data ?So that we can help you more clearly.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I tried it, but then I see the sum of all [CaseNumber] for all CreatedDates the same. No filter on the y-axis anymore.

So it is just the opposite of what I want, i.e. a working filter on the x-axis.

 

(I will see if I can generate a sample for you, I encountered some hick-ups to make it)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    And hereby the link to the sample file 

    Thanks again for your help! 🙂

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, Anonymous 

       

      Your data is not continuous, and the date column has a specific time.

      So you need to create a column and an additional date table,then use that date in slicer.

      Like this:

      Column = DATE(YEAR([CreatedDate]),MONTH([CreatedDate]),DAY([CreatedDate]))
Table = CALENDAR(MIN(testdataPowerBIcsv[CreatedDate]),MAX(testdataPowerBIcsv[CreatedDate]))

      Here is my sample .pbix file.Hope it helps.

      If it doesn’t solve your problem, please feel free to ask me.

       

      Best Regards

      Janey Guo

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Sorry for the late reply. There were some prio's changing in work, so I had to postpone the work on this.

         

        When relooking at the issue again, I used the Zoom sliders:  https://youtu.be/tZ9F19qTDCI

        Not sure if that functionality already existed when the issue started. Really happy with the result. Although your solution is probably much more prettier, this is an fast pragmatic solution. Thank  you for your patient in assisting me!