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 have a data set that I cannot change how it comes to me. I need to make a dashboard but the problem is the data is set up with times as columns and then the rows have multiple items needed also.
I need to be able to make separte charts for XXX/Alpha of the values by time, and then another for XXX/Beta of the values by time. And so on. The place colume has close to 1000 different items they type only has 4.
How do I set up a chart that shows the values with the times across the X axis and Values acros the Y using a filter on the chart to select the place and type?
Does this make sense? My brain has stopped working on this.
Solved! Go to Solution.
HI @finglonger76 ,
Consider unpivoting the time columns into a two columns : attribute (time) and value (the numbers /counts)
Once this is tabulated , the x axis would be (time) . Y axis could be either of the fields with the other one on the legend.
If you would like both fields to be on the Y axis, consider making a custom column concatenating both fields.
Kindly provide a sample input masking sensitive information if this does not resolve the issue.
HI @finglonger76 ,
Consider unpivoting the time columns into a two columns : attribute (time) and value (the numbers /counts)
Once this is tabulated , the x axis would be (time) . Y axis could be either of the fields with the other one on the legend.
If you would like both fields to be on the Y axis, consider making a custom column concatenating both fields.
Kindly provide a sample input masking sensitive information if this does not resolve the issue.
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 |
---|---|
39 | |
20 | |
20 | |
13 | |
13 |