Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi PBIXER,
I am trying to achieve a dynamic tile which is trying to give me a dynamic status of the process which has maximum error in the production something like below snapshot,
in the above case Finishing Issue has highest number 795 in all the issuess.
in the dynamic tile we want to display Finishing Issue.
This is related Quality check concept.
An swift reply will help,
Thank You in advance.
Solved! Go to Solution.
Hi @Anonymous
You can certainly write a measure that returns the Issue with the highest error value.
The basic structure of the measure is:
Dynamic title =
FIRSTNONBLANK (
TOPN (
1,
VALUES ( YourTable[Issue] ),
[Error Sum]
),
0
)
Note that you would have to write a measure [Error Sum] for this to work.
Ties are arbitrarily broken with FIRSTNONBLANK.
This pattern was taken from this article:
https://www.sqlbi.com/articles/alternative-use-of-firstnonblank-and-lastnonblank/
Does this work?
Regards
Owen
Hi @Anonymous
You can certainly write a measure that returns the Issue with the highest error value.
The basic structure of the measure is:
Dynamic title =
FIRSTNONBLANK (
TOPN (
1,
VALUES ( YourTable[Issue] ),
[Error Sum]
),
0
)
Note that you would have to write a measure [Error Sum] for this to work.
Ties are arbitrarily broken with FIRSTNONBLANK.
This pattern was taken from this article:
https://www.sqlbi.com/articles/alternative-use-of-firstnonblank-and-lastnonblank/
Does this work?
Regards
Owen
@Anonymous
Just following up, if you are wanting to show the error value as well, you could write something like either of these:
Dynamic title =
SELECTCOLUMNS (
FIRSTNONBLANK (
TOPN (
1,
VALUES ( YourTable[Issue] ),
[Error Sum]
),
0
),
"@Dynamic Title",
YourTable[Issue] & ": " & [Error Sum]
)
Dynamic title =
VAR IssueError =
ADDCOLUMNS (
VALUES ( YourTable[Issue] ),
"@Error", [Error Sum]
)
VAR TopRow =
TOPN (
1,
IssueError,
[@Error]
)
RETURN
MINX (
TopRow,
YourTable[Issue] & ": " & [@Error]
)
Regards,
Owen
@Anonymous To make it very clear, you are looking for a dynamic tile (to pin in a dashboard) that will display the category/status (a text field) based on the highest number of errors compared with all other categories/statuses.
Is that correct ? If yes, then you need to have a DAX Measure that will display that text field on the card and pin that visual to the dashboard. That will be dynamic based on the report refresh schedule.
Proud to be a PBI Community Champion
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |