Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have following information of inventory that needs to be presented in a Matrix visual as shown below (some are fields from table, some are measures ) -
Brand - field value from a Item table from Item table which is connected to Stock Table by Item ID
Sub Brand - field value from Item table from Item table which is connected to Stock Table by Item ID
item - field value from Item table which is connected to Stock Table by Item ID
stock qty - measure from stock table
listed sale price - measure from Price List Table where the Listed Sale price is stored
cost price - measure from Stock Table
margin - measures (calculated from Listed Sale Price and cost Price)
Stock received date - show the date hierarchy from Calendar Table which is connected to Stock Table by Received Date as the key
expected Matrix visual - present these under timeline of stock received date
2023
Jan23 Feb23 Mar23 Apr23
Brand Sub brand Item Cost Price Listed Sale Price Margin% stk qty stk qty stk qty stk qty
There was a solution using calcultion groups in following youtube video which i tried by creating a calculation group with calculation items for each of the measure with the IF(NOT(ISINSCOPE)) as used in the video, but when i bring it into the matrix visual as suggested and drill down by column, under each timeline it repeats the measure value instead of showing as a single column as shown in the video.
can anyone help?
Hi @GVTioluxe,
I'd like to suggest you take a look at the following blog about introducing and usage of calculation groups if it helps with your scenario:
Introducing Calculation Groups - SQLBI
Regards,
Xiaoxin Sheng
I haev gone through this tutorial as well as the one i had shared but the answer is not there
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |