Forum Discussion

abhishekc1's avatar
abhishekc1
Frequent Visitor
7 years ago
Solved

Dynamically change state based on date slicer - help required

Hi All,   I have a table that looks like this:   Location Start Date loc 1 1-Jan-19 loc 2 13-Feb-19 loc 3 17-Feb-19 loc 4 1-Aug-18 loc 5 1-Jun-19 loc 6 13-May-19 lo...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi

Share some data and in your expected format (with a slicer for time period applied), show the expected output with an explanation.

abhishekc1's avatar
abhishekc1
Frequent Visitor
7 years ago

Hi Ashish,

 

I just used the logic in your file and figured out a solution for my problem. I just created a month index and modified the logic from your solution. I'm very new to all of this so Thank you so much for all the help. Really appreciate it! Also, my apologies for not sharing enough details earlier. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    You are most welcome.  Glad you could find a solution by yourself.