Forum Discussion

yfquirogah's avatar
yfquirogah
Helper I
5 years ago
Solved

Slicer not removing dates from plot

I had to repost this issue because for some reason I wasn't able to respond to the original post to continue the trend 😕 So, here it goes again: Initially I was having an issue with the line chart,...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hiyfquirogah,

     

    Please check if this is what you need.

     

     

    you can try like this : 

    Amount New_Hires = IF(ISBLANK(SUM(New_Hires[Entries])),0,SUM(New_Hires[Entries]))

     

    Here is the demo : https://qiuyunus-my.sharepoint.com/:u:/g/personal/admin_qiuyunus_onmicrosoft_com/EeDbc-u2QThIoGwtCwjyPl4B0PEufZiQFON2SRX2kJW1Jw?e=WpviAf 

     

     

    Hope it helps.

     

    Best Regards,
    Caitlyn Yan

     

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

  • yfquirogah's avatar
    yfquirogah
    5 years ago

    I was finally able to find the answer to this problem:

    Cant. Ingresos = 
    var _Ingresos = COUNTROWS('Altas_2019-2020')+0
    var _min = MINX(ALLSELECTED(Calendario);Calendario[Date])
    var _max = MAX('FTE_2019-2020'[Fecha extracción])

    return
    CALCULATE(IF(MAX(Calendario[Date])<_min||MIN(Calendario[Date])>_max;BLANK();_Ingresos))

    With this measure I was able to make the chart plot the 0 but still keep the range within the selected dates.

     

    Thanks for your help.

VijayP's avatar
VijayP
Community Champion
5 years ago

yfquirogah 

Is this what you wanted to have ?!

 

  • yfquirogah's avatar
    yfquirogah
    Helper I
    5 years ago

    Not exactly, I tried the measure you recommended but the problem is still there, if you filter one of the smallest Entities such as Legal this is what it plots:

    It plots a straight line on 1 that would suggest every month there was one entry, it should go to 0 from Feb - Apr because there was no data there meaning there were no entries.