Forum Discussion

rashmij9's avatar
rashmij9
Frequent Visitor
2 years ago

Display Year as Row Header with Measure Breakdown

Hello,

 

I would like to display each Bucket Year as a row header with measure values broken down for each year. Is something like this possible in Power BI? 

 

1 Reply

  • Yes. For this you'll have to get pretty darn creative though.  I like to use Calculation Groups (which require a third party tool at the moment) to manage the formatting for different items (you can use SWITCH functions and formatting to conditionally format based on the SELECTEDMEASURE() and/or SELECTEDVALUE()).

     

    Because this is quite a complex topic I'll refer you to the YouTube videos by SQLBI on Calculation Groups