Forum Discussion
Weeknumber in Date
Hello,
How make that table column name will change depending on filter selection. For example, when we select value EUR, column name becomes APC, when we select Unit, column name appear IPC. column values consists of one measure. Values depends on filter selection. So how implement this?
Hi Analitika ,
You need to create a separate table.
Then use the following measure and fields in the matrix.
Measure_Total = SWITCH ( MAX ( Slicer[Name] ), "APC", [Measure 1], "IPC", [Measure 2] )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Analitika , A column name can not change based on slicer selection.
If you need measure slicer where names can change use calculated groups or new Field parameter (May 2022 update)
Hi Analitika ,
You need to create a separate table.
Then use the following measure and fields in the matrix.
Measure_Total = SWITCH ( MAX ( Slicer[Name] ), "APC", [Measure 1], "IPC", [Measure 2] )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
