Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
One of my columns looks like the one below and I use it to filter my visuals.
STORES
Store1
Store2
Store3
Store4
I have a bar chart and a KPI visual, both showing values for the stores above.
I want the KPI visual to filter by "Store4" when no store is selected from the bar chart but when a store is selected from the bar chart, I want the KPI visual to filter for that specific store.
Is it possible?
Thank you!
Solved! Go to Solution.
Hi there, what you could do is to create this measure below.
Measure = SELECTEDVALUE(Table1[STORES],"Store4")
What this will do above is return the selected value, if nothing is selected it will then return Store4
What you could do is put this into a Variable "VAR" in your measure, and then reference this variable. Here is an example below.
My Second Measure = VAR StoreSelection = SELECTEDVALUE(Table1[STORES],"Store4") RETURN CALCULATE([Sales Amount],'Mytable'[Store Name] = StoreSelection)
Hi there, what you could do is to create this measure below.
Measure = SELECTEDVALUE(Table1[STORES],"Store4")
What this will do above is return the selected value, if nothing is selected it will then return Store4
What you could do is put this into a Variable "VAR" in your measure, and then reference this variable. Here is an example below.
My Second Measure = VAR StoreSelection = SELECTEDVALUE(Table1[STORES],"Store4") RETURN CALCULATE([Sales Amount],'Mytable'[Store Name] = StoreSelection)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |