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,
I am transitioning from Tableau to Powerbi and am stuck on a problem.
I made a parameter that takes the average values of certain columns to filter visuals.
Please have a look at the below pictures to understand better.
I want to replicate the same in Powerbi and cannot do so by making a parameter.
This is the KPI Parameter that I created in Tableau
How it is applied in creating a chart in Tableau
The parameter in action:
Please help with any hints and suggestions that I can use to resolve this. Currently, this is what I did to replicate:
Not able to take averages here.
Hey, thank you for your response. I did the same but I need averages of the values that are going to be put as parameter fields. I am not able to do that.
Can you help me in this aspect?
@imaindia You want to select any slicer and that slicer value passes in the parameter? if I am not wrong.
Let me explain a bit more clearly, apologies if I was not clear.
I have a dashboard with multiple visuals which are connected to this parameter. So for example
In this dashboard I want these 2 visuals to be controlled with the help of the parameter selected KPI
for eg when I select numdirectors the average of numdirectors should be taken for the visuals.
similarly when promoters is selected both the visuals now show value with average of promoters.
I hope I am able to convey the query clearly now.
@imaindia you can go with the field parameter in power bi. for more information please refer below link. Thank YOU!!!
https://youtu.be/-nqEv2YXLsU
ELSE
Measure =
SWITCH(
SELECTEDVALUE(Table[Column]),
"A",[Measure1],
"B",[Measure2],
Blank()
)
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 |
---|---|
42 | |
26 | |
22 | |
11 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
17 | |
17 |