Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey,
I am trying to make a report including a Radar visual using TableRadar and I would like to display from another table TableProducts a list of rows that match the selection so that user can see details.
TableRadar
Type | Count |
X | 2 |
Y | 2 |
Z | 1 |
Where Count is defined as below
Count = CALCULATE(COUNT(TableProducts[Product]);FILTER(TableProducts;SEARCH([Type];TableProducts[Type list];;0)))
TableProducts
Product | Type list |
A | X, Y |
B | X |
C | Y |
D | Z |
As 'Type list' is made of a list of tags, I cannot create directly a relationship between the two tables so that a selection done in Radar can directly display list of rows. Any idea?
Hi @stchln
Can you explain a bit more what exactly you would want to have as final result? It is not quite clear
Cheers
When I click on the point x in the radar visual, I would like to see rows A and B displayed in TableProducts.
1. Eliminate the relationship
2. Create any of these two measures below ( the first one show all rows when nothing is selected in the radar, the second one shows nothing in that case)
3. Use the measure to filter the visual with TableProducts (show when result of the measure is 1)
ShowMeasure =
IF(
SEARCH(
SELECTEDVALUE( TableRadar[Type] );
SELECTEDVALUE( TableProducts[Type list] );
1;
0
) > 0;
1;
0
)
ShowMeasure2 =
IF (
COUNT ( TableRadar[Type] ) = COUNTROWS ( ALL ( TableRadar[Type] ) );
0;
IF (
SEARCH (
SELECTEDVALUE ( TableRadar[Type] );
SELECTEDVALUE ( TableProducts[Type list] );
1;
0
) > 0;
1;
0
)
)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Should I create one column per possible Type and then create several relationships?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |