Forum Discussion

Nareshbaabu's avatar
Nareshbaabu
Frequent Visitor
8 years ago
Solved

How do we bring Max and Min date values alone in Matrix visual in runtime user selection?

Hi    I want to create a Matrix visual which should restrict with min and max date values. Let me know how to we acheive this in PowerBI
General Comment
Need Help
Tips and Tricks
  • Nareshbaabu's avatar
    Nareshbaabu
    8 years ago

    Anonymous

     

    I got a requirement from client like. It'll have date column, Acc No, Amount. 

    User will select the two dates from Date slicer. And Matrix or Table visual will display values only for those dates. It'll have Max and Min date of selected between date.

    I've created a expression to overcome this.

     

    Got the solution by doing few work arounds.

     

    Thanks for your replies guys.

    Anonymous v-chuncz-msft

  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Nareshbaabu,

     

    Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.

Nareshbaabu's avatar
Nareshbaabu
Frequent Visitor
8 years ago

v-chuncz-msft thanks. I"ve used Max and Min expression to calculate my requirement. And got the solution.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Nareshbaabu,

     

    Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.