Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear colleagues,
I have a table that consists of ratings of 3 products. I wanted to present all the ratings on a single card in the PBI dashboard. I don't want to create three different measures for each product. You may refer the sample data and dashboard below. Appreciate your help.
Name | Rating on Product A | Rating on Product B | Rating on Product C |
Allan | 3 | 1 | 4 |
Raymer | 4 | 4 | 5 |
Johnson | 5 | 5 | 1 |
Donna | 1 | 2 | 4 |
Solved! Go to Solution.
Hi @bahare76 ,
Click on the product A column chart and then dynamically get the results of the card, there is no way.
But you can create a slicer and select different products in the slicer to get different results.
1.Create a seperate table.
2.Create a measure.
Average Rating =
SWITCH (
SELECTEDVALUE ( 'Table (2)'[Prduct] ),
"Product A", AVERAGE ( 'Table'[Rating on Product A] ),
"Product B", AVERAGE ( 'Table'[Rating on Product B] ),
"Product C", AVERAGE ( 'Table'[Rating on Product C] )
)
The result is as follows.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bahare76 If you want to do using measure so do like below:
@bahare76 Write AVERAGE instead of SUM in above measure.
Sorry, perhaps I was not making myself clear. I actually wanted to show the Product's average rating on the card whenever I click each column chart. So, for instance, if I click Product A column chart, I will get its average. Similarly, for Product B and C.
Hi @bahare76 ,
Click on the product A column chart and then dynamically get the results of the card, there is no way.
But you can create a slicer and select different products in the slicer to get different results.
1.Create a seperate table.
2.Create a measure.
Average Rating =
SWITCH (
SELECTEDVALUE ( 'Table (2)'[Prduct] ),
"Product A", AVERAGE ( 'Table'[Rating on Product A] ),
"Product B", AVERAGE ( 'Table'[Rating on Product B] ),
"Product C", AVERAGE ( 'Table'[Rating on Product C] )
)
The result is as follows.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bahare76 ,
You can unpivot only the 3 product columns so that they apper as single column as shown below
The Table will look as below
You can use this value column in a simple card visual to get the Average across Products
@bahare76 , Unpivot the table, split the column on last space into two column and get Product
https://radacad.com/pivot-and-unpivot-with-power-bi
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |