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 have 3 columns:
date, Location, Sales. Here is sample data.
I want to populate a table visual for Location-wise total sales based on slicer selection, where I would like to add a date hierarchy slicer (Year/Qtr/Month). and Table visual should filter based on that slicer.
Column Header should change based on slicer selection like in the below scenario:
Suppose is Year selected 2020 then the column header will show (2020 Sales).
If further Qtr1 is selected under 2020, then the column header will show (2020-Q1 Sales)
if further Month Name (Apr) is selected, then column header will show (2020-Q1-Apr Sales).
Thank you in Advance.
@amitchandak I want to add a YTD column as well which should not change based on the slicer. is it possible to have two columns (measures) one is for the selected month and another is for YTD?
@kulpowerbi , you can not change the measure header. But you can give dynamic title to visual
refer
https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |