Forum Discussion
Helper INumeric Range Slicer only use available values
Community ChampionI don't understand what you are asking. WHat months are 201833 and 201875?
If you want to have alternate values besides months in your slicer, either create a calculated column with your logic in it and use that as the slicer, or create a new column in Power Query with the logic you want and use that.
Helper IThey arent months?
Thats the issue, when using the numeric yearmonth field in my hardcoded datetable, in the numeric slider slicer, it will increase by increments of 1 and not skip to the next available value in the table.
example:
The slicer works like this
201812......201813......201814
but it should move up from 201812......201901
or 201799.....201801
when it should be 201712....201801
Does this make more sense?
v-juanli-msftCommunity Support
Hi jeffgarlisch
Assume you have a dataset like this,
"date" is numeric yearmonth field, but "date2" is the correct month associated with "date1", but "date2" doesn't exsit in your dataset.
Could you show me the first numeric yearmonth and the last numeric yearmonth, so i can analyze the rule to transform from this type numeric yearmonth to the correct date type.
Best Regards
Maggie
- jeffgarlisch
My Data Looks like this for the month year data, we store date dim data on a daily level so i selected the MIN and MAX of the datevalue column to show the date range of what the month year should be looking at.
Please let me know if this is what youre looking for.
- v-juanli-msft
Hi jeffgarlisch
From this table, i can't see anything like " 201812....201833.....201875".
Which column do you add in the slicer?
It is not clear for me how this table relate to your original table?
Best Regards
Maggie