Forum Discussion
Design a DBA Dashboard
Hi,
I'm trying to design a Dashboard to control the activity/errors/issues related to our databases. For this purpose, I have created a very easy table with only three columns. KPI, value and timestamp. My target is to create a simple panel (maybe with tarjet cards) that shows the last value of each KPI.
AS you can see, I'm saving in my table historical information, but I only want to show the las timestamp row of each KPI (marked in bold).
| KPI | Value | timestamp |
| Average CPU time | 10% | 2020-08-20 09:20 |
| Average CPU time | 12% | 2020-08-20 09:22 |
| Average CPU time | 2% | 2020-08-20 09:24 |
| Free Memory | 70% | 2020-08-20 09:21 |
| Free Memory | 75% | 2020-08-20 09:22 |
| Free Memory | 10% | 2020-08-20 09:24 |
Honestly, I have tried but I haven't found the way to do it. ¿Could you please help me?
Thanks in advance.
@JIblasco - You can create a selector for this
Selection selector for selection options
VAR __Max MAXX (ALL('Table'),[timestamp])
Return
IF(MAX('Table'[timestamp]) at __Max,1,0)
See Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Also, maybe Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Hi , JIblasco
As mentioned by amitchandak ,please create a calculated column:
Rank = RANKX(FILTER(ALL('Table'),'Table'[KPI ]=EARLIER('Table'[KPI ])),'Table'[timestamp],,DESC)And applied it to filter pane:
Best Regards,
Community Support Team _ Eason
4 Replies
JIblasco , Take these two measures along with KPI in you visual
new timestamp = lastnonblank(table[timestamp],blank())
new Value = lastnonblankvalue(table[timestamp],max(Table[Value]))Or create a Rank of time inside KPI and filter on 1
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415Hi,
Thank you for your quick response. I have decided to create a view in the database with the las timestamp of each KPI. Anyway, thank you for the rank refers.
Hi , JIblasco
As mentioned by amitchandak ,please create a calculated column:
Rank = RANKX(FILTER(ALL('Table'),'Table'[KPI ]=EARLIER('Table'[KPI ])),'Table'[timestamp],,DESC)And applied it to filter pane:
Best Regards,
Community Support Team _ Eason@JIblasco - You can create a selector for this
Selection selector for selection options
VAR __Max MAXX (ALL('Table'),[timestamp])
Return
IF(MAX('Table'[timestamp]) at __Max,1,0)
See Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Also, maybe Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
