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.
Hello dears,
I have to replicate the table attached below in Power BI and I have found some issues.
On the rows, there are periods (months) on the columns the economic indicators.
The problem is to show the actual (CST) and the BDG values on the rows and not on the columns.
Thanks in advance for your help!
@Matteoss , seem like breaking of measure into dimension and measure.
You have take help of union and summarize, need to include all group by or filter
example
union(
summarize('Table','Table'[Version_Id],"Var","Variable 1", "Sum",sum('Table'[variable 1]), "Count",count('Table'[variable 1])),
summarize('Table','Table'[Version_Id],"Var","Variable 2", "Sum",sum('Table'[variable 2]), "Count",count('Table'[variable 2]))
)
or
union(
summarize('Table','Table'[Type],"Measure","Qty", "Budget",[Budget], "Sold",[Sold], "diff",[diff]",diff %",[dif%]),
summarize('Table','Table'[Type],"Measure","Amnt", "Budget",[Budget], "Sold",[Sold], "diff",[diff]",diff %",[dif%])
)
or
union(
summarize('Table',"Measure","Sales Growth", "ACT",[Sales Growth], "PY",[Sales Growth PY], "FC",[Sales Growth FC]),
summarize('Table',"Measure","Price Growth", "ACT",[Price Growth], "PY",[Price Growth PY], "FC",[Price Growth FC])
)
or refer this
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
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |