Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |