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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jjkennyan0
New Member

eliminate the need of adding a filtering column to a table visual?

Hello! What to i need to do in order to eliminate the need of adding a filtering column to a table visual? Background: I have a table with records of sales for a bunch of stores. These stores are categorized by concept. I've set up a dashboard to benchmark a selected stores sales with the average sales per item of the corresponding concept group. I've written some dax which I think is working correctly, but only when add the concept name column to the table. When omitting the concept name from the visual it just returns the global average sales of all stores per item, regardless of concept.

 

I have used the following Dax:

 

*Calculate(Averagex(
(Summarize(Store,StoreConcept,StoreName,[Sum_Sales]),
Allexcept(Store,StoreConcept)
)
*

 

which seems to work fine as long as the concept name is added to the visual. Can I hide this column in the visual, or is there something need to do with my DAX code? Highly appreciative of any help or nudge in the right direction, many thanks!

 

1 ACCEPTED SOLUTION

@jjkennyan0  You can hide a column with color settings under Conditional Formatting. Choose to affect both values and column names. Normally I used this method for overcoming the severe limitations of column sorting. I created some fixed measures with. ie. a value of one, then used it in some conditional formatting rule, etc

View solution in original post

4 REPLIES 4
ray_ux
Memorable Member
Memorable Member

@jjkennyan0  You can try adding concept name (or id) as a visual level filter and use "not blank" 

Thanks for the quick reponse.  Is there a way to do it without having show it on the filter pane?

@jjkennyan0  You can hide a column with color settings under Conditional Formatting. Choose to affect both values and column names. Normally I used this method for overcoming the severe limitations of column sorting. I created some fixed measures with. ie. a value of one, then used it in some conditional formatting rule, etc

Wow, i didn't know that was possible. Cheers! 😊

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.