Forum Discussion
create matrix dashboard with single measure
Hi Experts,
i want to create a matrix dashboard as given below.i have created
2 Replies
- amitchandak
Super User
PSan1979 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Matrix should help: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
For column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795 - v-deddai1-msft
Community Support
You can use the SWITCH function to your measure. Please try something like:
Measure = SWITCH(True(),MAX('Table'[Value1]) = "SCORE"&&MAX('Table'[Value2]) = "ACT",....,MAX('Table'[Value1]) = "SCORE"&&MAX('Table'[Value2]) = "FST",.......)If you need an accurate formula, show us sample data or onedrive pbix file for business if possible.
If this post helps, then consider Accept it as the solution to help other members find it faster.
Best regards
Dedmon Dai