Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago
Solved

Dynamic Chart

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.

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    1 year ago

    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

     





  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    1 year ago

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