Forum Discussion
Solved
Dynamic text based on Month Name IMPOSSIBLE?
Power BI Community, Reaching out for help! I want to create a dynamic text that changes based on the filtered selection. I have been attempting to use if and iscrossfiltered in DAX. I don't k...
Anonymous
Problem Solved...
The "-1" in the current month line had to be changed to a "0".
Many thanks,
Gdexter
Hi Anonymous,
Thanks for the solution. The second formual worked form (I had to change isfiltered to iscrossfiltered) but instead of showing the selected month and the month before the selected month, the month before the selected month is shown twice. I have attached image below.
Can you suggest a fix for this?
Also including the actual formula I used, in case you wish to confirm.
Many thanks,
Gdexter
Anonymous
Problem Solved...
The "-1" in the current month line had to be changed to a "0".
Many thanks,
Gdexter