Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am very new to PowerBI. Is it possibe to create a matrix with the measures in both columns and rows. I have 3 metrics going across and row with 4 metrics going down the page (12 total). Data is coming from Teradata database.
Yes, you should be able to do this, you would want to turn off the default "Stepped" layout for rows. You may also need to use the disconnected table trick. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...
I don't see how this applies to what I am trying to accomplish as I really am such a newbie. But, I don't have missing data as I have only one fact table. There are columns for sales and targets. The report will show sales, a measure that shows variance to target and YOY sales.
I have Category in the Rows and Product in the column.
For each Category/Product I need to show 4 rows of various categories of sales with 3 metrics each as shown discussed above.
So for
Product 1 Product 2
Category 1
sales 1 - variance 1 - YOY sales 1 - variance 1 - YOY
sales 2 - variance 2 - YOY sales 2 - variance 2 - YOY
sales 3 - variance 3 - YOY sales 3 - variance 3 - YOY
sales 4 - variance 4 - YOY sales 4 - variance 4 - YOY
Category 1
sales 1 - variance 1 - YOY sales 1 - variance 1 - YOY
sales 2 - variance 2 - YOY sales 2 - variance 2 - YOY
sales 3 - variance 3 - YOY sales 3 - variance 3 - YOY
sales 4 - variance 4 - YOY sales 4 - variance 4 - YOY
All Category/Product combination have values for each of the 12 metrics.
I need 3 columns of metrics for each of the 4 sales values.
I actually figured out a different workaround.
My orginal fact table had
attribute 1, attribute 2, attribute 3, posted sales, gross sales, traffic, close
I created a lookup table
1=posted
2=gross
3=traffic
4=close
then created summary tables that I merged together and used type to group by
attribute 1, attribute 2, attribute 3, NEW Type, Actual
that's a bit of a simplified explanation
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |