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 @vinod116m,
Suppose you have columns [Date], [Category], [Intent], [Type] and [Item] in your source table. To show Day/Week/Month on X-axis, you shoud first create these values based on [Date], then, place these three columns in "Axis" section of line chart. You can click the "Drill Down" button on the top left of the chart to dynamically change the level of hierarchy.
Day=Day('TableName'[Date])
Week=WeekNum('TableName'[Date])
Month=Month('TableName'[Date])
To show data values grouped by category and intent, you can add [Category] and [Intent] into "Legend" section.
To filter chart by option provided for Intent, Category, Type and Item, please add slicers into report page, and display the above fields you want into slicers. Line chart will show corresponding data based on your selection.
Regards,
Yuliana Gu
User | Count |
---|---|
82 | |
77 | |
62 | |
60 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |