chart visualization
2 TopicsPower BI: Dynamic Top N Filtering Based on Selection?
I have a Power BI table with three columns: ID, Title, and Name. I created two clustered bar charts: Chart 1 → Shows the Top 3 Names (Y-axis: Name, X-axis: Count of ID). Chart 2 → Shows the Top 3 Titles (Y-axis: Title, X-axis: Count of ID). Each chart has a visual-level filter applied to show only the top 3 based on ID count. Issue: When I select a Name in Chart 1, Chart 2 updates, but it does not recalculate the top 3 Titles based on the selected Name—it just filters the existing top 3 Titles. Similarly, selecting a Title in Chart 2 does not dynamically update the top 3 Names in Chart 1. Desired Outcome: If I select a Name, I want Chart 2 to show the Top 3 Titles related to that Name (not just filter the default top 3). Likewise, selecting a Title should update Chart 1 to show the Top 3 Names related to that Title. Note: There are more than 1000 records in my table, and there are more than 20 distinct Titles and Names each. Is there a way to achieve this in Power BI?Solved1.1KViews0likes3CommentsHow to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill
I need help with filtering by Day, Week, Month, Quarter, and Year. I created a field parameter called "Period" and attempted to build a line chart using Year and this parameter. However, when users select a date range longer than a year, I don't want the weeks to overlap. Currently, every time I switch between Month and Quarter, I have to use the drill down feature on the chart. Is there a way to achieve this without having to drill down, or is there a simpler solution?1.5KViews1like1Comment