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.
I want to make a chart for the run date and status but it wont work? How do I do it?
Solved! Go to Solution.
Hi @hima2002 ,
Unfortunately you cannot change, but you can use numeric values instead of Succeeded and Failed. You can create a column.
column=if('table'[states]="Succeeded",1,if('table'[states]="Failed",0,blank()))
Then you can put the column to the Y axis.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes I want my Y axis to be in Text form (either Failed or Success) but it won't let me, it changed to count of.
Is there a way to do that.
Hi @hima2002 ,
Unfortunately you cannot change, but you can use numeric values instead of Succeeded and Failed. You can create a column.
column=if('table'[states]="Succeeded",1,if('table'[states]="Failed",0,blank()))
Then you can put the column to the Y axis.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The end output is as follows:
The runtime on the X-axis, and the Status (Succeeded or Failed) on the Y-Axis.
Hi @hima2002 ,
The value on Y axis may be Numeric form. It seems the data your provided are text type on the Y axis. Please remove the status to the legend or use the number.
If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |