I have two date columns in my table and I am using a slicer in my report. So I will use the final date in my slicer when I choose for final date and otherwise.
Can someone help me?
Thanks in advance.
Hi @BYENER ,
Based on your description, I can probably understand what you think.
It should be pointed out that measure cannot be used as slicer content. To switch slicer options, you could use bookmarks and buttons to switch reports.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@BYENERI understand you wish to have unique values from two date columns which you want to use in your slicer. You can create a new table, in powerbi desktop go to the New Table option and paste the below code. It will create a another table with unique date field from two date columns.
No, let me explain. Every row has two dates, creation date and final date. I have a report overview where I want to filter on creation date and sometimes on final date. So for that I want to use a chicklet visual. If the user will use the final date in the slicer then he/she has to click first on date type "Final date" and after he/she can use the slicer.
Can you explain with an example what you are trying to do exactly?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
@BYENER , You need to join both of them with the date table and use userelation to switch it based on slicer selection
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.