cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
kivcek
New Member

How to show the results of multiple ISFILTERED in separate lines

Hello,

I would like to add an button to my report to show which filters were selected. Is there a way to show the information about each filter in a separate row ? I used "//" as separator but I think it would look better to have them arrange one below another.

 

kivcek_1-1633607974452.png

I would like to see the output like this :

Active Filters:

Regions :  xxx

Tier Group: xxx

Sales Person: xxx

etc.

This is the code I used

kivcek_2-1633608078683.png

 

Thank you

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@kivcek , code seems fine to me, what is the issue you are facing.

I don't want to see the result concatenated in one line but for each listed filter I would like to have a separate row (instead of "//" as separator I would have new row). So it will look like this :

Active Filters:

Regions :  xxx

Tier Group: xxx

Sales Person: xxx

etc.

Insted of having it like this 

Active Filters: Regions :  xxx //, Tier Group: xxx //, Sales Person: xxx // etc.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors