Forum Discussion
Data Condition
Hi All,
I have a table as :
Date-------Name----------------------------NameValues
On based of above I need to create graphs as:
For each name I need to call Name data per Date. date X axis, NameValues Y axis.
Please advise the approcah. Thanks
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.
7 Replies
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.
