topic Re: Data Condition in DAX Commands and Tips

Data Condition

sdhn — Thu, 02 Dec 2021 16:33:46 GMT

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

Re: Data Condition

bcdobbs — Thu, 02 Dec 2021 16:48:16 GMT

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.

Re: Data Condition

sdhn — Thu, 02 Dec 2021 17:18:07 GMT

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

Re: Data Condition

sdhn — Thu, 02 Dec 2021 17:26:44 GMT

Thanks. I figured out to restrist. I used Edie Quiery and check only wanted data. I hoghly appreciet your help

Re: Data Condition

bcdobbs — Thu, 02 Dec 2021 17:57:24 GMT

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.

Re: Data Condition

sdhn — Thu, 02 Dec 2021 18:06:47 GMT

Hi there,

How?

I followed above suggestion and got almost all things. Only issue its showing all graphs togather. I wanty separate graphs.

one for Human_Visits

one for Bot_Visits

I want as:

Re: Data Condition

sdhn — Thu, 02 Dec 2021 18:08:33 GMT

and total on left sites as second snap_shot

Re: Data Condition

bcdobbs — Thu, 02 Dec 2021 19:55:58 GMT

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.