Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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?
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).
@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?
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).
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |