cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anantha Frequent Visitor
Frequent Visitor

Conditionally display columns based on options in report filters

I want to select certain options based on report filters. If the column doesn't have any value, is there any way to not display it

5 REPLIES 5
ankitpatira Super Contributor
Super Contributor

Re: Conditionally display columns based on options in report filters

@Anantha can you provide some more information ? If you are using column chart for example, and have dropped field into Axis, if that column doesn't have any value x-axis isn't going to show anything.

Anantha Frequent Visitor
Frequent Visitor

Re: Conditionally display columns based on options in report filters

Let's say I have 2  report fileter one for country (India, US, China) and one for Cities(Delhi, Mumbai, nyc, Shangai)

 

and my data in excel is structured as follows

 

Country    City        Comments   country                            Comments city

India       overall     econmoy doing good

India       Delhi                                                                Delhi is the capital

US         overall     US is the world's richest economy

US        nyc                                                                     major business hub

 

 

Now, if I select India in my country filter and don't select any city, I want only the comments from the column 'Comments country' i.e (economy doing good ) to be displayed

If I choose India and delhi, I want the comments from column 'Comments  CIty' (Delhi is the capital) to be displayed

However, I don't want the "economy doing good" to be shown 

Is there any way to do this?

BrentA Frequent Visitor
Frequent Visitor

Re: Conditionally display columns based on options in report filters

I would build a calculated column to filter on that conbines the columns and use that as the filter such as;

Location = CONCATENATE([Country]," " && [City])

Then add that as the slicer.

 

Although I would have thought that when you select Delhi it would only bring back that row anyway.

 

Moderator v-caliao-msft
Moderator

Re: Conditionally display columns based on options in report filters

Hi Anantha,

 

According to your description, you need to display columns based on the filter value you selected, right?

 

Based on my research, it's not supported to display or hide a column base don conditions. So I am afraid your issue cannot be acehieved currently.

 

If you have any concer with this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

ampac New Member
New Member

Re: Conditionally display columns based on options in report filters

Hi,

 

I have a requirement where based on Country filter I need to display selected  columns values from a table function. How can I achieve this.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors