Forum Discussion

jrnunsys's avatar
jrnunsys
New Member
5 years ago

Line Chart Show empty dates as 0

Hi! I have a table (a Sharepoint list really) where i manually add each post from my company and I have the following columns: Topic (basic idea of the post) Content (long text area) Date (date ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

@jrnunsys , +0 to the extent you can do that. But this can show all dates.

Try a meausre like

0 entre rango
Medida = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
devolución
CALCULATE(if(max('Calendar'[Fecha]) <_min || max('Calendario'[Fecha]) >_max , BLANK(), _1))

jrnunsys's avatar
jrnunsys
New Member
5 years ago

Hi amitchandak , I am quite a newbie here so I actually can't figure out how to implement that.

Any way you can lay out some steps to follow?

 

Thanks!

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  jrnunsys ,

     

    Can you attach your .pbix file here if there's no confidential information inside?Or could you provide some sample data with expected output?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!