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
i have a fact table with order lines connected to dimdate table.
i want to viusal results in matrix , that in the rows i will have the orders PO and lines and in the columns i will have work weeks.
at the end of the matix instead of total column i want to have selected week or week of my choice calculation
like this:
@Anonymous
@Anonymous , If week is used as column(pivot), and want a custom week then you need Hydrid table or change grand total using isinscope or isfiltered
if(isinscope([Week]) , [Meausre], [Measure with custom week])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |