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 PBI Community,
I have a requirement in which the user would make a Selection on the below Filter. The Below is the Screenshot of the Filter.
Once the user makes the selection. The Selected Value should appear under Current Week, The Previous Week to it should appear under Previous Week and the 13 Week Average should have the value of the last 13 Weeks previous to the Previous Week.
Eg: If i Select "2019w15" in the Filter, the Current Week Column will have the value "2019w15", The Previous Week Column will have the Value "2019w14" and the 13 Week Average will have the value "2019w11-2019w13".
P.S: I am able to bring out the Selection using a SELECTEDVALUE(). mapped it on a KPI and super-imposed the KPI over the Column name but when i Click on the Table the Original Column names appear.
Hi,
Thanks for your Suggestion. As I have mentioned above, the Expected Output is the below. For Instance, When i select the above filter as 2019w25, then the below should be the output on the Table Column Headers. Hope this Clarifies?
hi, @Anonymous
Do you mean that you want the column name is dynamic? If so, According to my knowledge, it couldn't achieve in power bi for now. The column name couldn't be changed dynamically.
Best Regards,
Lin
Yes that is Right. The Column name should be resolved dynamically. I know that the Column name would accept only string values but this is the Requirement.
I have also tried a workaround of Placing Three Different Measures (KPI Cards) super-imposed on the Table Column Headers make the Font Colors go (Green) so that the Column header Value is not shown but clicking on the Table is automatically bringing out the Original Column Headers.
hi, @Anonymous
As a workaround, if you could try Conditional formatting for visual titles
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/#dynamicTitles
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-format-visual-titles
Best Regards,
Lin
This is the Title for the Table and the one I would want to format is the Column Headers of the Table.
hi, @Anonymous
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
and for the 13 Week Average will have the value "2019w11-2019w13". If it should be "2019w1-2019w13"?
Best Regards,
Lin
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 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |