The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello folks,
Im working on 3 separate databases (sales for 2021, 2020, 2019) which they resemble the operating years of x department. Im trying to use a graphic to show some features of these items sold (in this case would be size) and I would like to use a single graphic to show this. Is this possible?
Thanks again,
@Shackwell
It depends. The first suggestion would be to append the three tables using power query then you can slice by year.
If you want to keep them splitted for some reason, and you are for example slicing by product then you need to have a product dimention table that contains a unique list of all products. Can be easily created using power (preffered) if not possiblr then it can be created using simple DAX code. Would you please provide more details in order to assisst you further. Thank you.
User | Count |
---|---|
69 | |
66 | |
62 | |
48 | |
28 |
User | Count |
---|---|
112 | |
83 | |
66 | |
48 | |
43 |