Forum Discussion
Dynamic Legend Based upon Slicer- Error Counting
Issue Requesting Receiving 1 A B 2 A B 3 C A 4 D A 5 C D 6 B C 7 D A 8 B C 9 D A Basically I want to be able to filter on either receiving or requesting side and show the Attrbiute
Example show me receiving and pick Attribute A and get the copy of B, C, D, etc. I am getting an error that the text can't be converted to true/false. If you don't mind sharing the PBIX file, that would be great.
Thanks!
Anonymous Thanks for providing the sample data.
Here is my solution:
Steps:
1. Unpivot the main data table for the Receiving and Requesting column. The table should look like this after Unpivot:
2. Create the relationship between the two tables. The data model should look like this.
3. Create a measure for Unique Count:
Unique Count =
CALCULATE (
COUNT ( 'Issue Table'[Value] ),
'Issue Table'[Value] = SELECTEDVALUE ( 'Issue Table'[Value] )
)
4. Create a slicer and chart in the Report. The visual should look like this:
Hope this helps.
|
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you ! Good Luck 👍 |
Thanks. I am assuming that your attribute table literally has two rows, 1 receiving and 1 requesting? Otherwise you have a many to many relationship.