Forum Discussion
Dynamic x axis numbering based on filtering
HI rishikhurana,
Perhaps you can take a look at the following blog to use the 'unpivot columns' feature to create a dynamic attribute report:
Dynamic Attributes In A Power BI Report - P3 Adaptive
Regards,
Moonlight
Community ChampionCalculated columns are not dynamic. They are calculated when the model is loaded. If you want the top 8, there is an option in the filter pane for the visual. In the filter pane, for the Peer column choose TopN from the deopdown, type in 8 and add the measure you have in the visual for the TopN calculation ("Based on" I think it's called in the filter options -I'm not in front of a pc now so can't check the exact expression)
Thank you Paul for your reply. However, I dont need TopN here, what i need is to name the bars as 1,2,3, so on. based on the selections made. Just need to hide the names ABC, DEF, GHI etc, basically if presenting this dashboard to the client ABC, we dont have to identify DEF, GHI etc but just as other normal peers. Hope it clarifies. Thanks!