Forum Discussion
Creating a table with a dynamic filter that changes based on slicer
Hello all! I am trying to create a report that gives Sales figures by Fiscal Year and Fiscal Week from a Power BI dataset that has daily level data (I am doing a lot more, but for illustrative p...
Hi,
You should create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag year and Month name from the Calndar Table. Write this measure
Total = sum(Data[sales])
Hope this helps.