Forum Discussion
Chart is not displayed by using parameter
Hello guys, I am a newbe and I am trying to build a parameter for smallmultiples.
This is my data set
I am trying to build Small Multiples for every supply type (Versorgungsart). The idea is to use the columns 'Establishments,' 'remuneration,' 'hours worked,' and 'persons employed' (Betriebe, Entgelte, geleistete Arbeitsstunden und tätige Personen) as filters. For this, I've created a parameter. I would like to switch between 'Establishments,' 'remuneration,' hours worked,' and 'persons employed' for each supply type.
The result should looks like this
But It doesn't work. The problem is (what I assume) I couldn't link the parameter to the viz. And this is the result.
Does anybody have any idea how can I fix it? I would really appriacet your help!
2 Replies
- amitchandakSuper User
Pamela_26 , I am able to use both measure and axis field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllEIn case you are looking for measure as small multiples
Calculation Groups - Use Measure with small multiple: https://youtu.be/LEn6ZnScMZc
- Pamela_26Frequent Visitor
Hi Amit, thank you for your respons and all the links! The video is exactly what I want and on your screenshot I see the solution. However, I recreated the case and I still have the problem. I need to create something what you created with "Measures". Could you please have a look in my workbook?
"Kategorieauswahl" (choice of category) is my parameter.
If I create a simple table, the parameter works. But it doesn't work with SmallMultiples.