Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
So I've got an issue that seems like it should be simple to change, but I just can't work it out.
I'm using a matrix to display date by day of the month, with different metrics & want to compare 2 months - something like this:
However, it's is grouping the metrics by date (bins) (February & March in this case), but I'd like to have the metrics side by side for each month. In a PivotTable, you can just swap "Month" & "Values around, like in this example:
But I can't figure out how to do that here.
Anyone to the rescue?
Thanks,
Patrick
Does anyone know if this is possible by now? I also use measures and the problem is not in my data.
Thanks,
Devon
Hi @patrick3,
Suppose the source table structure is similar to below. Under Query Editor mode, select [Leads], [Sales] and [ScvR] fields together, click "Unpivot Columns" to convert table structure.
You will get a new table like this:
When create the Matrix visual, add [Value Type] on the top of [Date(bins)] in "Columns" section. Also, click the third drill down icon.
Best regards,
Yuliana Gu
There is a "work around" this problem.
Step 1. Create a Table in your model specifying 2 Types of data (works with any quantity), in this case Sales and Leads. Your Table will have 2 columns, Id and Type with these values, Id 1 Type "Lead", Id 2 Type "Sales".
Step 2. Create a measure with a switch,
Hi @v-yulgu-msft,
Thanks that's very helpful - not quite the solution I need, as SCvR is a measure rather then a column.
Regards,
Patrick
Hi @patrick3,
That case, I'm afraid it is not able to change the Matrix structure as you required.
Regards,
Yuliana Gu
Hey,
currently this is not possible in the MATRIX view.
I recommend to create an idea on ideas.powerbi.com
Regards
Tom
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |