Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning
I have calendar table, and another table that contains days, months only for 2017, but in the report slicer I can select dates from 01/01/2010 to 18/05/2037!!!
Can I restrict this, according some criteria or table?
Thanks a lot
Daniel
Solved! Go to Solution.
Hi @danielsouza,
In the visualization at the bottom you have 3 options for filters: Visual Level filters, Page Level Filters and Report Level Filters.
Add your date column to your page level filter and select 2017, there is also option for relative date filter.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAlternatively, you can also filter out the dates you don't want using advanced filtering option under report-level filters.
Proud to be a Super User!
Hi @danielsouza,
I see one of two ways of doing this:
Change the start date of your generic date table to make it to the 2017 start and end today that way the table will grow in time.
Add the generic calendar date to Report filter option and choose the starting from 2017 or a relative slicer with the last X months, days, years.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix, I cannot change the initial time of my generic date table because I'm using it to another reports with distinct dates intervals.
The second option I don't know how to do this...
dCalendario is the generic table:
Hi @danielsouza,
In the visualization at the bottom you have 3 options for filters: Visual Level filters, Page Level Filters and Report Level Filters.
Add your date column to your page level filter and select 2017, there is also option for relative date filter.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks man! That's it!
How can you record your screen like that?
Hi @danielsouza,
I use and application to make a GIF image.
Check http://www.screentogif.com/ and it's pretty easy to use.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |