Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I would like to have all of the below product types in my slicer so i can check waste volumes by product type, in a graph.
Something is not working though and i think it is because of the sum sign next to each name below?
Please can you support,
Thank you
Jerry
Solved! Go to Solution.
Hello,
You won't be able to simply drag the fields into a slicer to have them be selectable. What I would do is create a table in your model that lists your product types. Go to your Relationships view in your model file. On the Home tab, click Enter Data (in External Data section). then manually input the product types you want in your slicer. You can name your column "Product Types". Click Load, this will create your table. You'll also need to link it up to the main table that'll have these product types. After creating the relationship, you will be able to drag this column into a slicer. It'd look something like this:
@jhaldane as @AlexisOlson mention, unpivot your data and then set the relationship between two tables.
Unpivot is easy, selected first two columns and then choose "unpivot other columns", you will get two columns "Attribute" and "Value", rename those columns whatever you want and go from there.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Oh wait, I just realized that you have number values in those fields...doh.
Are those tracking the number of product types for a specific type? Like your Paper field is actually the number of products with type paper?
Hiya
The information is waste data.
So Paper and how many tons were generated in each month
Similairy Metal and how much was generated each month
Ive done the table, but, when
- i select product data type and
- i select what year
- Nothing appears on my graph 🙂
hello 🙂
I thought i had done that: see below
If you unpivot those ProductType columns, then it will be much easier to work with.
@jhaldane as @AlexisOlson mention, unpivot your data and then set the relationship between two tables.
Unpivot is easy, selected first two columns and then choose "unpivot other columns", you will get two columns "Attribute" and "Value", rename those columns whatever you want and go from there.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello,
Right, to do it this way you'll need something similar in your other table for it to filter correctly. You'll need a Product Type column in your main table, then create an active relationship between the 2 tables connecting Product Category to Product Category.
Hello,
You won't be able to simply drag the fields into a slicer to have them be selectable. What I would do is create a table in your model that lists your product types. Go to your Relationships view in your model file. On the Home tab, click Enter Data (in External Data section). then manually input the product types you want in your slicer. You can name your column "Product Types". Click Load, this will create your table. You'll also need to link it up to the main table that'll have these product types. After creating the relationship, you will be able to drag this column into a slicer. It'd look something like this:
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |