Dynamic matrix column headers based on user selection

[Elderin]

I'm fairly new to power bi but I've done some prior work in Tableau.  In my Tableau reports, I was able to create a calculated field (I called it "Period"), which, based on a dropdown selection, would translate a date into its date, week,  month, quarter, or year value.   I would then use the calculated field as the column header in their matrix.  

The end result is that by simply selecting daily/weekly/monthly/quarterly/yearly from a dropdown, the user would change the matrix to display data by the selected period breakdown.

Does anyone know how to do this in Power BI?

[Eric_Zhang · Accepted solution]

---

@Elderin wrote:

I'm fairly new to power bi but I've done some prior work in Tableau.  In my Tableau reports, I was able to create a calculated field (I called it "Period"), which, based on a dropdown selection, would translate a date into its date, week,  month, quarter, or year value.   I would then use the calculated field as the column header in their matrix.  

The end result is that by simply selecting daily/weekly/monthly/quarterly/yearly from a dropdown, the user would change the matrix to display data by the selected period breakdown.

Does anyone know how to do this in Power BI?

---

@Elderin

Not the exact equivalent, but you can check Visual hierarchies and drill-down behavior and Use the new Matrix visual in Power BI Desktop (Preview).

[nickythakkar]

We are also looking for similar feature where based on Time Slicer (Date/Month/Quarter/Year) selection Dynamically column header should change to reflect trailing Twelve measures - this reply does not help. It still remains the issue any help?