Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I'm facing an issue to have my filter correct: Data is shown as following:
type |
20 |
25 |
30 |
35 |
40 |
all |
When making a slicer to filter for different types it will exclude all when a value other than all is selected. However I want to have the slicer to show values for the all types also when something other than all is selected so that the user won't have to allways select the all type when filtering data.
If you need more info feel free to ask! Thank you in advance!
Solved! Go to Solution.
Now I think I get your idea.
I will create a measure like this:
SUM( Your column cost ) + CALCULATE ( SUM( Your column cost ) , FILTER ( Your table, Your column cost = "TypeAll")
That way you always have the cost of each type plus the all cost typeAll.
On the slicer I would hide the typeAll for not duplicate values if the user select TypeAll.
This is solve your problem?
Proud to be a Super User!
Thanks for your explanation, but it's still hard for me to think of a solution without seeing the data and how it relates or without a concrete example of what you have now and the end result you want.
If you can, read this article, which is a good summary of what you need to do to be able to help more effectively.
Proud to be a Super User!
I will try to explain as much as possible:
I'm building on a new way to visualize costs based on a scenario. Let's say there is a ID that holds to following data:
ID | Provider | Location 1 | Location 2 | Type | cost_amount
The provider is the company arranging the transport and the ID is the contract holding this information. In this contract there are cost types with their price, that may differ based on the container size. Like I said, the cleaning costs can be based on this size, also the transport price can be based on the size. However some costs, like handling, are not effected by the size. When filtering through scenarios, we select the size of the container, the weight, the locations to have the report show the ID/contracts that may arrange the selected transport. Currently when I put lets say type35 in the transport it will exlude the costs that are for all types, because this is labeled as TypeAll. I don't want to always have to select All but I want to have All allways selected. When the user selects type35 it also must show the costs with TypeAll.
Now I think I get your idea.
I will create a measure like this:
SUM( Your column cost ) + CALCULATE ( SUM( Your column cost ) , FILTER ( Your table, Your column cost = "TypeAll")
That way you always have the cost of each type plus the all cost typeAll.
On the slicer I would hide the typeAll for not duplicate values if the user select TypeAll.
This is solve your problem?
Proud to be a Super User!
Hi @bnjmnnl,
Did it solve your problem?
Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out
Proud to be a Super User!
Please provide more information about your date. What values are in the Type column?
How is your model related?
Proud to be a Super User!
The values in the type column are sizenames for containers. There are prices linked to those types, some prices are not only for one type but for all types (all value), for example:
Cleaning costs | type20 | 100$
Cleaning costs | type35 | 120$
Handling costs | typeAll | 30$
In this scenario, the 120$ costs for cleaning only counts for the 35 type. The handling costs are for all types en therefore adds to the 120$.
In a report I want to arrange a filter section with multiple slicers to explain a situation and have all related costs shown but I don't want the user to always select "All" to have the costs shown. Does this explain enough?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |