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.
I have two columns in a table in one is called
warehouse and one is called factory
For example factory is
Atlanta
Nashville
Birmingham
Warehouse
Juno
Los Angeles
New York
They are two seperate column.
My question is can I create a parameter that lets me choose which column I want to display
in my matrix row.
For example if I want only matrix I can pick parameter Matrix
and I get
Atlanta
Nashville
Birmingham
Solved! Go to Solution.
Hello,
Yes you can add them both as field parameter and put the value in the matrix and you can change between them using a slicer.
First you go to the modeling tab then new parameter then pick fields
after that add the factory field and the warehouse field and click create
You'll now have a slicer and a table with this new parameter that has the field, so drag this field to a matrix and use the slicer to switch with the field you want
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! | |
Hello,
Yes you can add them both as field parameter and put the value in the matrix and you can change between them using a slicer.
First you go to the modeling tab then new parameter then pick fields
after that add the factory field and the warehouse field and click create
You'll now have a slicer and a table with this new parameter that has the field, so drag this field to a matrix and use the slicer to switch with the field you want
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! | |
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |