Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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:
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.
and total on left sites as second snap_shot
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.
Thanks. I figured out to restrist. I used Edie Quiery and check only wanted data. I hoghly appreciet your help
Thanks
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
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |