Scatter chart dot size based on slicer vale selected

[arimoldi]

Hi,

I have a scatter chart where on the X axis I have the quarters (2023 Q4, 2023 Q3, etc) and on the Y axis I have a value from 1 to 4 and I would like to make the dot related to the selected quarter in the slicer bigger than the others.

How can this can be achieved?

Any suggestions?

Thanks,

Andrea

[Anonymous]

Hi, @arimoldi 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Add this measure to the Size area of the view object.

Measure:

Selected Dot Size = 
IF (
    SELECTEDVALUE ( 'Table'[date].[QuarterNo] )
        = SELECTEDVALUE ( 'Table 2'[date].[QuarterNo] ),
    20,
    5
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[arimoldi]

Hi,

thanks for reply.

It is working, but now the issue is that in the dashboard I have other charts based on the same table ("Table" in your example) that need to be updated selecting the year quarter, but in this way the year quarter table is not linked to "Table".

How can I manage this?

Thanks,

Andrea

[Anonymous]

Hi, @arimoldi 

Didn't understand what you meant by (need to be updated selecting the year quarter), can you describe your need in more detail?

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[arimoldi]

Hi,

I mean that with this solution the dataset 'Table' must not have a relationship with the dataset 'Table 2' (calendar table), otherwise it is not working, but in this way all the other visuals in the page that are based on 'Table' are no more dependent on the date slicer which is based on 'Table 2'.

Did you get what I mean?

Thanks,

Andrea

[Anonymous]

Hi, @arimoldi 

Yes, I see what you mean, and in fact, your needs would conflict with the current version of the feature. If you don't use the dates in Table 2 for filtering, then the dynamic comparison effect will be difficult to achieve. If the Slicer is created using the date columns in Table, then once there is a selection, the Scatter Chart will only have data for that one quarter and the comparison effect is lost. For the sake of comparison, and because the date filter in Table 2 works on other visual objects, you can use measure on other visual objects to connect to the Slicer, thus filtering on that visual object. If it's possible, you can submit an idea for here and the product team will take note of such a need.

Related Link: New tab (powerbi.com)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum