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.
Hi All,
I have a report which contains 'Date' slicer.
I want to create 2 variables which will store the Date values for last month and month before last values based on slicer selection.
For example, if user selects 1 March 2017, then the 2 variables should have values as 1 February 2017 and 1 January 2017 respectively.
Once I have these 2 date values I need to update the header text of table columns.
Please let me know of how I can achieve this.
Thanks in advance.
Regards,
Vinayak
Not aware of a way that you can do that as described.
Thank you for your comment @Greg_Deckler
I am evaluating custom visual approach to achieve this functionality.
Hi Vinayak,
I am also looking for same scenario and global variable to acheive this.
could you please suggest how you resole this case.
Regards,
Deeksha
Hi Deeksha,
I was unable to achieve it using global variables at that time.
However I had developed a custom visual similar to the 'table' visual available by default in Power BI.
It would dynamically change its column header values as per the date value selected in date slicer.
Hope this helps.
Regards,
Vinayak
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |