Forum Discussion

maxduff59's avatar
maxduff59
Icon for Helper II rankHelper II
3 years ago

Show items with no data in a specific range

Hello, I am facing an issue in Power BI.  I have a table 'Calendar - Weeks' that contains all values in this format 'YYYY - WW'. It is linked to a table containing data on sports activities. Some ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
maxduff59's avatar
maxduff59
Icon for Helper II rankHelper II
3 years ago

I tried that options but when I do that it is also showing values that are not in my date range 😕

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi maxduff59 ,

 

Are both table related? To my knowledge and the tests that I did if you select values from a slicer and then do the show items without data it will only present the value inside the slicer selection:

 

However if you are using an unrelated table with a measure this then can return values, how is your model setup?