Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I have 2 Tables. One table having column Universal message Id and another table having the 2 columns Permalink (Url) & Themes.
Note:
1. Permalink having duplicate. Same permalink present in multiple themes.
2. I'm Caluclating TOP 5 Themes based on distinct count of Universal message ID.
Requirement: (Chart: Donut)
If we select Top 1 theme then list of the all the permalink count of TOP 5 themes expect the selected theme.
If we select Top 2 theme then list of the all the permalink count of TOP 5 themes expect the selected theme.
If we select Top 3 theme then list of the all the permalink count of TOP 5 themes expect the selected theme.
If we select Top 4 theme then list of the all the permalink count of TOP 5 themes expect the selected theme.
If we select Top 5 theme then list of the all the permalink count of TOP 5 themes expect the selected theme.
This here is a forum where users help users. For urgent requests contact a Microsoft Partner near you.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...