Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a big table (about 8 millions records), and this table has 10 fiels that indicate if a customer has or not a specific product. This is an Example:
Table1:
HasProductA | HasProductB | HasProductC | HasProductD | HasProductE...
yes | no | no | yes | no...
I would like to have a Slicer with all the products, so users are able to select one or more products. Currently, I have multiple slicers that looks awful.
I think that that will be possible only if I have all this fields combined into one... but How should I do that?
Thanks
Thanks
Solved! Go to Solution.
If you want to have this in once slicer, the relevant column names must become values in a column.
To achieve this you must unpivot them.
Then delete the rows with "no" .
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous ,
Do you also have a products table? We will need to see more. If you do, are the customers and products table related?
Thanks,
Nathaniel
Proud to be a Super User!
Hi Nathaniel
No, I don't have a product table. I have a big table that is denormalized, i.e Products are in the same table that customers.
Should I try to normalize it? Or it may be dangerous?
Thanks
@Anonymous ,
Lets reach out to @ImkeF . She is a wiz!
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
If you want to have this in once slicer, the relevant column names must become values in a column.
To achieve this you must unpivot them.
Then delete the rows with "no" .
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |