Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm trying to create a matrix, which can show different calculations depending on slicer selection:
For example if Sellout is selected in slicer 1, and Base Volume (Kg) is selected in slicer 2, then the matrix will show SUM(Fact_Sales[Base Volume (Kg)], and so on.
This is working as intended at the moment, however, the Date Field in the matrix columns also needs to change depending on what is chosen on slicer 1:
SellIn -> Date field should be F_Sales[Sellin_Date]
SellOut -> Date field should be F_Sales[Sellout_Date]
Any ideas?
Hi @vrumay2
If you have an inactive relationship between 'Date'[Date] and F_Sales[Sellout_Date] then you need to use CALCULATE - USERELATIONSHIP to activate that relationship when calculating SellOut. If you don't have such realtionship created already then create it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
27 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |