Forum Discussion
Create attribute for week/month/quarter to use with multiple measures in matrix
I'm trying to recreate this table in Power BI:
I have measures for lost customer, inactive customer, and new customer. I also have measures for lost customer - week, lost customer - month, lost customer - quarter, inactive customer - week, inactive customer - month, inactive customer - quarter, etc. Based upon the date in the visual filter, the first column should return the total for the selected week, selected month, and selected quarter.
I'm creating reports in the web service and trying to find a creative way to create this chart (made in Excel) in Power BI. There is no One Drive for Business or SharePoint team site available so I can't just pin the chart from Excel to my Power BI dashboard.
I tried multi-row cards, but the lack of ability to control the number of items and the truncation of category labels makes it a poor option. I tried creating one table per row, but it leaves way to much white space when I pin the tables to a dashboard.
I'm hoping there is some creative DAX (maybe a disconnected table?) that I could create to make the week/month/quarter values into a single attribute by which I could then filter my measures. But I'm not seeing how that is possible.
I ended up solving my own problem and blogged about it here. I already had the date table and the base measures. So I added a disconnected table that would let me put the metrics in an atrribute so they could go on rows. Then I added some calculated measures to use the disconnected table. I made one measure for weekly, one for monthly, and one for quarterly and placed them in Values.
I think Power BI should be able to accomodate putting measures on rows in a matrix. Please vote for this feature request here.