Forum Discussion
Need help with Dax
Hi,
I have the a visual (waterfall) that displays the last 12 week. The 12 weeks is filtered using a visual level filter. Now the users need to filter a year, for example: when the year is current year (users might place a filter on year) the visual must remain as it is - displaying last 12w (202548...202606), but this is not happening.
The way I thought I'd solve the problem was using variable called "tablefilter" and, when I transfered it to the calculation it didnt work.
How could I achieve that using Dax?
Like, if user select year, and the year is the latest year, then the waterfall must keeping display the last 12 week. Today, the visual is filtered. The year filter comes from the lateral filter pane!
Code:
tablefilter
)
Year is filtered:
Hi,
Please share the download link of the PBI file. Ensure that there is a calendar table there with a column of week numbers.
3 Replies
- Ashish_MathurSuper User
Hi,
Please share the download link of the PBI file. Ensure that there is a calendar table there with a column of week numbers.
- v-priyankataCommunity Support
Hi MacedoLuiss
Thank you for reaching out to the Microsoft Fabric Forum Community.Ashish_Mathur Thanks for the inputs.
As suggested by user,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?How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thanks.- v-priyankataCommunity Support
Hi MacedoLuiss
Can you please share the sample data, so we can work on the things to achive your requirement.Please show the expected outcome based on the sample data you provided.
Need help uploading data?How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thanks.