Forum Discussion
Show columns and values on rows in same matrix
OK so apologies for not updating this sooner. I was quite successful in finding an "Aging Bucket Column" method to re-create the SSRS report in Power BI. I won't get into the minutae of how I was able to set this up but anyone interested can messsage me for help on that.
Here is a link to an anonymized version of the report: https://klcoles-my.sharepoint.com/:u:/p/kevin/EZi6bxKDN3xCvOcF7wR0UsABMeJIi2zt_ciJTv5iwN2eGA?e=fF0yE1
I know have 2 more issues I'm hoping someone can help with:
Problem 1: Using this bucketing system, the columns are actually dynamic and as such I seem to have lost the ability to sort them when published. This is quite important because the users will want to sort on the oldest WIP in days to quickly identify it. Or perhaps someone can suggest some other option? Maybe a quick aging filter?
Problem 2: On the original SSRS report, the Held rows (Held Labor, Expense and Units) would only display if there wa data for the row. Is there a way I can accomplish this in Power BI?
Thank you in advance!
Kevin
Below is a screenshot of how it looks now in Power BI: