Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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)
)
*
Solved! Go to 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
@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! 😊
User | Count |
---|---|
139 | |
70 | |
68 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |