Forum Discussion
Dynamic Column Name depending on Slicer
Good day,
I've been working with a Visual that shows Vol with the option of choosing from two separate slicers the periods of time you want to compare.
One takes info from a basic Date table in this format (spans from JAN22 to NOV24):
| DATE | YEAR | MONTH | MONTH NAME | #MONTH | #DAY | #WEEK | WEEK | WEEKEND? | WEEKDAY | QUARTER | MW# | SEMESTER | SortMonthYear | M-Y | SortTrimYear | T-Y | SortSemYear | MES ESPAÑOL | MES AÑO | INDEX |
| 01/10/2024 | 2024 | OCT | OCTOBER | 10 | 1 | 2 | 40 | False | TUESDAY | 4 | 2 | S2 | 202410 | OCT-24 | 202404 | T4-24 | 202402 | OCT 2024 | OCT 2024 | 57 |
The second one comes from a summarized version of the first:
| MONTH | MES ESPAÑOL | YEAR | INDEX |
| JUL | JUL 2022 | 2022 | 30 |
| AUG | AGO 2022 | 2022 | 31 |
The current month is calculated with VOL= SUM('Query O2C'[VOL]) filtered by the first slicer, the previous year with VOL AA = CALCULATE(Measures[VOL], DATEADD(dDate[Date], -12, MONTH)) and VOL M2 with:
From this:
Slicer 1 linked to dDate[MES ESPAÑOL]: JUN 2024
Slicer 2 linked to MONTH 2[MES ESPAÑOL]: MAY 2022
Visualization:
| VOL AA | VOL M2 | VOL CM | DIF VOL AA | DIF VOL M2 | |
| Retail | 4140000 | 4244000 | 4236000 | 91000 | -8000 |
| Wholesale | 1130000 | 1231000 | 1154000 | 16000 | -77000 |
To this:
| VOL JUN 2023 | VOL MAY 2022 | VOL JUNE 2024 | DIF VOL AA | DIF VOL M2 | |
| Retail | 4144000 | 4244000 | 4236000 | 9100) | -8000 |
| Wholesale | 1138000 | 1231000 | 1154000 | 16000 | -77000 |
I've tried using these two in Dynamic fields to pull the name:
- SELECTEDVALUE
- IF(ISFILTERED('MONTH 2'[Mes ESPAÑOL]), CONCATENATE("VOL ", (IF(HASONEVALUE('MONTH 2'[Mes ESPAÑOL]),FIRSTNONBLANK('MONTH 2'[Mes ESPAÑOL],"") ,""))), "SELECT A MONTH")
However it has come to my attention that Parameters are incapable of considering the filters despite working perfectly fine as an independent measure. Is there a way to work around this?
Appreciate the help.
4 Replies
Hi CBAEZA
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...Fixed the post following your instructions. I'd be happy to add or change anything that I could be missing. Thank you for your help.
Hi, CBAEZA
May I ask if your problem is solved? If not resolved, can you provide sample data and your expected output? This will better describe your problem. How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Excuse me, is there a way to refresh the post or can I post it again with the change for it to be seen properly?
