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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
RonaldL
Frequent Visitor

Show bar filtered in a card from Field parameter slicer

RonaldL_0-1702619950933.png

I want to show which bar has been filtered in a bar chart and show that in a card. The bar chart is filtered with the help of field parameters.

I made this measure and it works because I hardcoded the correct column Plantation in the measure. If a filter the slicer to e.g district it does not work.
How should the measure be configured?

2BarSelected =
Var FilterSelected = SELECTEDVALUE('Slice by'[MeasureName]) <- name of field parameter generated slicer
VAR Validselection = ISFILTERED(ImmigrationRegister) <- the barchart I am filtering
VAR _bar = SELECTEDVALUE(ImmigrationRegister[Plantation]) <- this the column
RETURN
_bar

Ronald

 

5 REPLIES 5
Anonymous
Not applicable

Hi @RonaldL ,

Can you explain how these two fields are related?

vjunyantmsft_0-1702887360451.png

Best Regards,
Dino Tao

They both come from the same table. The slicer is generated by the filed parameter function. In the figure I filtered the data by plantation and the plantations are shown on the Y-axis of the bar chart

RonaldL
Frequent Visitor

I need to show the filtered entry of the bar chart (Tres Amigos) in the card. The measure you are proposing and I am using extracts the selected slicer entry (Schip). See image.


pic1.png

@amitchandak 
I need to show the filtered entry of the bar chart (Tres Amigos) in the card. The measure you are proposing and I am using extracts the selected slicer entry (Schip). See image.


@RonaldL wrote:

I need to show the filtered entry of the bar chart (Tres Amigos) in the card. The measure you are proposing and I am using extracts the selected slicer entry (Schip). See image.


pic1.png





swikritee_p
Resolver II
Resolver II

@RonaldL , In case you need selected value of the field parameter, you can refer to the  measure below

What is selected = maxx(filter(‘Axis Slicer’, ‘Axis Slicer’[Axis Slicer Order]= SELECTEDVALUE(‘Axis Slicer’[Axis Slicer Order])),’Axis Slicer’[Axis Slicer])

 

Refer https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors