Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |