Forum Discussion
Responsive ResidentData 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
- bcdobbs
Community Champion
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.
sdhnThanks
We have many unwanted names too. For example we have 100 names and we need graph for only 4. How to restrict to only wanted names. Thanks
- sdhn
Thanks. I figured out to restrist. I used Edie Quiery and check only wanted data. I hoghly appreciet your help
- bcdobbs
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.