Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi ,
I have two different tables table1 has category and table 2 has category and sub category In Power BI, I want the result to be shown in as
1.compare sales and qty column as category and subCategory in one column (i.e. in output image I have created 2 different column chart I want it as one )how can I get it by DAX
2.category name should come first(from left) on axis
sharing some images for better understanding
Hi @Anonymous ,
I did a test using similar data to yours, and I wonder if this is what you are trying to achieve?
Compare their respective sales and QTY with category and sub-category as X-axis?
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
HIi @Anonymous , I am wondering why you need to the two tables in the data model. The Sub-Category contains all the data need to create the two visuals you have shown. If you are trying to add a reconciliation between the two tables, I would recommend using Power Query to compare the two tables. If there is an issue, then report this exception in Power BI.
If you want to compare using DAX, you will need to create Bridging Tables for Date and Category. These tables can then be joined to both tables. When they are joined, these table will apply filters to both tables. You will be able to compare the Sum of table 1 to Sum of table 2, and calculate a difference. Please watch the following GuyInACube video to understand this: Handling MULTIPLE fact tables in Power BI - YouTube
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |