Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Highlight a Scatter visual.

Hi everyone.

 

I have a problem to get a visual result.

 

First, I wanna to Filter with Categorie and after per Product.


The problem happens when I Select per product, the Scatter visual erases the others products of the categorie and I want to Highlight the product (Yeah The filtering is the problem... I think that I Need to make this with DAX to ignore the Filter but I'm lost).

 

 

 

for example:

 

DuvianS_5-1655853403122.png

 

I Want to get this when I selected a product in a panel Filter(Highlight the product in the visual).

 

DuvianS_3-1655852865159.png

 

 

Not this: 

 

DuvianS_4-1655852899066.png

 

Ty very much.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

In fact, Dax function cannot directly affect existing visual filters. You need to change the visual value field to measure expression will all function to ignore the filter effects.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBIa

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

In fact, Dax function cannot directly affect existing visual filters. You need to change the visual value field to measure expression will all function to ignore the filter effects.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBIa

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.