Forum Discussion
Data Condition
You should be able to use the line chart visual.
Put date column in the Axis box, NameValues in the Values box and Name in the Small multiples box.
Make sure in the Values box the default agregation is set to SUM.
Power query certainly would do it. However if you want the rest of the data else where in your report...
Click on the visual and you should see names in the filter pane. You can just restrict the list there at visual level.
Hi there,
How?
I followed above suggestion and got almost all things. Only issue its showing all graphs togather. I wanty separate graphs.
Like
one for Human_Visits
one for Bot_Visits
I want as:
and total on left sites as second snap_shot
Ok.
Ignore the small multiples aspect and create a separate line charts for each name. On the filter pane you can set a visual level filter for each to restrict to a specific name.
To get the total on the left use a card visual and drop the names value into the value field.
Then just need to format and position. Looking at the graphs you sent I think you need to set the dates to be just dates rather than date time fields.
