Dynamic Chart

[Syndicate_Admin]

Hello everyone

I have these two objects in a display box:

And I would like, when I selected a month, on the same graph, to see the results by day. In this other way:

The X-axis field is different, but you could have it all in one field. The two photos are different graphics, but I want to have everything in one. Would it be possible? I can't find the way...

Thank you.

[Syndicate_Admin · Accepted solution]

Thank you very much, it has been of great help to me! Best regards

[Fowmy]

@Syndicate_Admin 

You can achieve this using Field Parameters. Create the following measure and assign it to the visual using TOPn
File is attached below

Axis Selection = 
VAR __MonthFiltered = INT(ISFILTERED('Dates'[Month Name]) )
VAR __Result = INT( MAX(Periods[Periods Order]) <> __MonthFiltered )
RETURN
    __Result

No Months selected, it shows by months.

One Month is selected, it shows by date