Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello, this is not as simple as it sounds. Lets say I have data :
Type | Value |
a | 5 |
a | 20 |
b | 15 |
b | 10 |
c | 15 |
c | 30 |
And I want a matrix like this :
Type 1 | Type 2 |
value | value |
value | value |
Where the types columns are linked to a dropdown where you can select a, b or c.
Is this possible?
Solved! Go to Solution.
Hi @314mp_M0th4 ,
If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @314mp_M0th4 ,
If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! I also found that I am a dummy and by using basic filtering on page from the filtering pane you get the same result as using a dropdown.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.