The StateCountry column is needed to create a relationship with the Slicer table that shows the possible choices in a single item. StateCountry = COMBINEVALUES ( "|", Customer, Customer ) The Continent column is not required because each Country belongs to only one Continent – in a different situation, consider concatenating all the columns that define a unique value for each row of the table: Because the State value may be repeated, we create a calculated column in the Customer table by concatenating State and Country. The first step required in order to implement the solution is to create a calculated column in the Customer table that defines the granularity for the filter. The requirement is to enable a filter over California ( State), France ( Country), and Asia ( Continent) using a single slicer, as shown in the following screenshot. Technically, this is not possible in Power BI through the standard visualizations, but you can use a particular data modeling technique to obtain the desired result.Ĭonsider the case of a Customer table with a geographical hierarchy with Continent, Country, and State. Power BI provides slicers for single columns, but there are scenarios where it could be useful to consolidate alternative filters for multiple columns into a single slicer.
0 kommentar(er)
