Forum Discussion
Drill Through with comma separated values
Team,
I’m trying to understand whether the following drillthrough behavior is achievable in Power BI.
Scenario:
I have a bar chart with 4 categories:
A, B, C, D
Drillthrough is enabled on this bar chart using the category field.
Data structure (backend):
The underlying column that drives the drillthrough contains comma-separated values, for example:
A
A, B
B, C
Expected behavior:
When I drill through on bar A, I want the drillthrough page to show:
Rows where the value is A
AND rows where the value is A, B
In other words, the drillthrough should behave like a “contains” match rather than an exact equality match.
Current behavior:
Power BI drillthrough only shows rows where the value is exactly A
Rows like A, B are excluded
Question:
Is there any supported way in Power BI to:
Expand drillthrough results to include rows where the drilled value is part of a comma-separated list
Or override the default equality-based drillthrough behavior?
Any guidance, limitations, or recommended modeling approaches would be appreciated.
Hi Anonymous,
The “Query has exceeded the available resources” error in Power BI occurs when the engine is unable to process a query due to limitations in memory, CPU, or execution capacity. This issue is related to the system's capacity or the complexity of the query, rather than a DAX syntax error.
To resolve this issue:
- Avoid using a measure as a visual-level filter on a detailed table.
- Incorporate the logic into the data model by creating a calculated column, such as
Has Affiliation Change = IF ( CONTAINSSTRING ( 'AFFILIATION CHANGE FLAG'[affiliation_change_category], RELATED ( 'Dim Affiliation Category Bridge'[affiliation_change_category] ) ), 1, 0 )Use slicers or dimension tables to apply filters, rather than using measures.
Thank you.
15 Replies
Awesome
You can create measures that you can use as visual filters (as long as the measure itself is not rendered in the visual).
In your measure convert the comma separated list to a path (replacing comma and space with pipe) and then test with PATHCONTAINS.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi Anonymous,
Have you had a chance to review the solution we shared by lbendlin? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi Anonymous,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
