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.
Hi,
Is it possible to dynamically filter a graph based on a selection on a slicer. Here's the best theoretical example:
Firstly we have an hierarchial slicer of the following
SELECT ALL ->
Region (top level) ->
Country ->
City
And a graph that displays "Total population"
Lets say that if you had "Select All or Nothing" selected then the graph would filter by region level
So you Y AXIS would be
Europe || South America || Asia
and your X Axis the count
if we wanted to drill further into this and see specific stats for EACH country inside of Europe. You select this on your hierarchial slicer and then the graph will populate the Y AXIS as the following
United Kingdom || Germany || Belgium
Still having your A Axis as the count.
Going further you'd then drill down into country and filter by City.
Is this possible to do dynamically using a single Hierarchial Slicer?
Thanks in advance,
@HePowerBI , not very clear,
The best you can do is have a field parameter - https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Hi, let me try add a little more context. (Field paramaters aren't what I am after)
Lets say I have a single graph on my dashboard. This graph currently measures the total population (Y) by region (X). So currently my Graph will display
|
|
|
|
Total Pop(Y) |
|
|_________________________
Region (X)
So under region (X) would be
EUROPE || Asia || South America
Lets say I introduce a Hierarchial slicer which has the following Hierarchies
[] SELECT ALL / ERASE (No selection)
[]EUROPE
[]UNITED KINGDOM
[]LONDON
[]GERMANY
[]BERLIN
[]ASIA
[]CHINA
[]BEIJING
[]INDIA
[]NEW DELHI
So my question is, using the above slicer. Can you filter a graph dynamically so it reacts to the choice of the selector. So for example
[] SELECT ALL / ERASE (No selection)
[X]EUROPE <-- Slicer selection
[]UNITED KINGDOM
[]LONDON
[]GERMANY
[]BERLIN
[]ASIA
[]CHINA
[]BEIJING
[]INDIA
[]NEW DELHI
I choose europe. The then above graph will update its X AXIS to show all the countries listed within europe. So in the case of this slicer
United Kingdom || Germany
and the Y AXIS will update to the current population of those.
Further more, if i were to then drill down on UNITED KINGDOM. It would then update the X AXIS to cities WITHIN United kingdom.
Hope this clears things up
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |