Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How do I show a date based on a selected value?

My dataset has 3 columns: Date (date), Energy_Consumed (numeric), and Energy_Consumed (kw) (decimal).   In my report, I have a card that shows the highest energy consumed (using the Max summarisati...
  • mrcss23's avatar
    3 years ago

    Hi !

    Each card can have only one data. So I just you to create an additional card with the information of the date when the energy consumed is max.

     

    You can download here

    - a database in excel (similar to the one you describe) and

    - a pbix created to see 2 cards. 1 card has the max value and 1 card has the date when the max value appear.

    hope it helps