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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.