Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello ,
@Anonymous I created a funnel chart to compare sales of my selected country w.r.to other countries,the country which i selected will be taken as 100% and will be compared with rest of the countries...but I want one selection as fixed,and remaining as dynamic ..how to do that?? In the below picture i want canada country as fixed and i want toselect some countries dynamically as per my requirement.
In the above picture,I want Canada as fixed selection and i want to select some other countries(selection is dynamic) for comparison against canada.
Solved! Go to Solution.
@Likhitha - That's correct, unless you use a disconnected table for your filter. To do that:
1. Create a new table with all of the countries, except Canada. Do NOT make a relationship to this table.
2. Create a new measure which returns TRUE() for the selected values + Canada and FALSE() otherwise. You can accomplish with the following Measure:
Include Country Measure = var country_to_check = SELECTEDVALUE(ExistingTable[Country]) var hard_coded_country = FILTER(ALL('NewDisconnectedTable'[Country]), 'NewDisconnectedTable'[Country] = "Canada") var selected_countries = VALUES('NewDisconnectedTable'[Country]) var unioned_countries = UNION(selected_countries,hard_coded_country) return country_to_check IN unioned_countries
3. Add the new measure as a filter on your visual.
Hope this helps,
Nathan
@Likhitha - If I recall correctly, the slicer that you show is a disconnected slicer. If you want to limit the countries, you can create another slicer on the same column that you are using in the funnel chart.
Does that solve the problem?
Nathan
@Anonymous if i use other country column,i have to select canada country every time manually and after that the countries which i want
@Likhitha - That's correct, unless you use a disconnected table for your filter. To do that:
1. Create a new table with all of the countries, except Canada. Do NOT make a relationship to this table.
2. Create a new measure which returns TRUE() for the selected values + Canada and FALSE() otherwise. You can accomplish with the following Measure:
Include Country Measure = var country_to_check = SELECTEDVALUE(ExistingTable[Country]) var hard_coded_country = FILTER(ALL('NewDisconnectedTable'[Country]), 'NewDisconnectedTable'[Country] = "Canada") var selected_countries = VALUES('NewDisconnectedTable'[Country]) var unioned_countries = UNION(selected_countries,hard_coded_country) return country_to_check IN unioned_countries
3. Add the new measure as a filter on your visual.
Hope this helps,
Nathan
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |