Forum Discussion
Using a Relative Time Stamp (MM/DD/YYYY HH:MM:SS) filter to set start and end fiscal month?
Hi Folks, I currently have a date/time dimension that spits out a timestamp in (MM/DD/YYYY HH:MM:SS) format. The timestamp is compatible with the Power BI relative date filter/slider - works exce...
kentyler
Solution Sage
Solution SageCan you post a small sample file... power bi can be a little different than excel in refering to values in columns
unfortunately, my corporation does not allow me to upload/share files.
all I can do is suggest solutions that I think will work, but I have struggled with...
for example, I have a field connected to the timestamp called 'monthnyear' that is basically in the format I need it. Issue is, it is not able to be leveraged in a relative filter.
It is not like I can create two simple dropdowns called "min monthnyear select" and "max monthnyear select" and have the data filter between the values. That would be ideal, but I'm not aware of a way to make that happen.