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
ChandraSekhar77
Frequent Visitor

How to turn off clustered column chart Grey Out when selecting slicer

Hi,

 

I am using clustered column chart for some of my visualizations in management reporting. Whenever we select any item from the slicer, the visual gets changed as per the image below (the full value is greyed out and the selected value is highlighted). Is there any way to turn off the greyed-out part altogether?

I want when a slicer item is selected, only the data pertaining to it is displayed.

Any help in this regard is much appreciated.

 

ChandraSekhar77_0-1618989543193.png

 

1 ACCEPTED SOLUTION
HarishKM
Impactful Individual
Impactful Individual

@ChandraSekhar77  Hey ,

select that any other chart  then go to format then edit intraction .
Now choose filter instead of highlighing .

HarishKM_1-1618991594984.png

Sample .

HarishKM_2-1618991632157.pngOnce changed to filter then output will like this only.

HarishKM_3-1618991658795.png

 

 

 

 

 

 

 

View solution in original post

2 REPLIES 2
ChandraSekhar77
Frequent Visitor

Thanks, it worked! 😀

HarishKM
Impactful Individual
Impactful Individual

@ChandraSekhar77  Hey ,

select that any other chart  then go to format then edit intraction .
Now choose filter instead of highlighing .

HarishKM_1-1618991594984.png

Sample .

HarishKM_2-1618991632157.pngOnce changed to filter then output will like this only.

HarishKM_3-1618991658795.png

 

 

 

 

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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