Forum Discussion

ITManuel's avatar
ITManuel
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Show items with no data -- Date range limitation issue

Hi all,   I know there are several threads about this topic out there, but so far I couldn't get to the right answer.   I come accross this issue several times and even I was partially able to so...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    ITManuel 

     

    create a calculated column im dimdate table , as follow : 
    01.01.2024 and 08.05.25

    switch( true() , 

    dimdate[date] >="2024-01-01" && dimdate[date] <="2025-08-25" , 1, 0 )

     

     

    then set this calculated column on the filter pane, filter on page,   and set it  = 1 . 

     

     

    let me know if this works for you .

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

     

LinnCh's avatar
LinnCh
New Member
2 years ago

Hello, 

 

the solution in visual 4.0 seem to be what I need to solve my issue, however I am very new to PBI and I cannot understand how to use the formula in my own data.

 

Background: I have a dataset with continues dates and multiple articles. I want to show the sales on these articles with the option of filtering down on individual articles. When filtering some dates do not have data and then the x-axis do not show the dates. I would like to see the whole timeline although no data. 

 

Could you please help me?