The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Any one could you please help me on Dynamic Column Name change Based on Slicer Selection.
below is the senario.
Matrix visual
product Name Year
XXX 56
YYY 87
ZZZ 78
Slicer Selection
Year
2016-17
2017-18
2018-19
2019-20
when i select year 2017-18 , column name on matrix should change dynamicaaly as Year 2017-18 .
Any idea please?
Not sure why you would want to do that but have a look at Field Parameters.
Hi, yes indeed, I use field parameters. I need to dynamically change the field name based on periid slicer.
You are not "dynamically changing field names", you are swapping colums in and out. The result is the same.
is there a way to rename dynamically the filed name based on slicer please? this is exactly my problem
No, there is not. But using Field Parameters you can make it look like that.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |