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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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