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.
Hi All,
I have a question about the filter.
In the tableau tool i am able to set what values i want to show in the Filter.. but i did not find this function in Power BI.
For example: Below i have a date filter which has all the month/year that i have in my dataset.
However, i just want to show the dates from 2017' - those filters i use to compare vs YAGO, so.. it doesn´t make sense to me to see the values from 2016 for exemple, once that i do not have information about 2015.
Can anyone help me, please? 🙂
Thanks in advance.
Felipe Lima
Solved! Go to Solution.
Hi @Fexlima,
In the slicer visual you cannot had level filters to it however you can add the date to the Page/Report Level filters and then take out the dates you don't want and all the information will be filtered by that including the slicers. This as custom filter to do before, after, between.
Page filter will only be at the page you are seeing, and Report level will be for all the pages in you report.
This as a problem for me is that when you change year or date you have to reset your filter to the new year and republish the dashboards personnaly I prefer to add a slicer with Year and the one with dates so when users select a certain year the other slicer only show the date for that year.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Fexlima,
In the slicer visual you cannot had level filters to it however you can add the date to the Page/Report Level filters and then take out the dates you don't want and all the information will be filtered by that including the slicers. This as custom filter to do before, after, between.
Page filter will only be at the page you are seeing, and Report level will be for all the pages in you report.
This as a problem for me is that when you change year or date you have to reset your filter to the new year and republish the dashboards personnaly I prefer to add a slicer with Year and the one with dates so when users select a certain year the other slicer only show the date for that year.
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 |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |