Custom Comparison Period calculations not working correctly in visuals with dates
Hello, i have a dashbaord that is using a comparison date table, the configuration is such that Im able to select any custom dates to compare my current date range with. Im then calculating % increase/decrease based on the 2 date ranges selected. This seems to be working fine for visuals where the measure isnt broken down by a date dimension, however when i have visuals such as the following: For the comparison period it shows me the same value across different months. I understand this is because im using the months from the primary date dimension table but ideally, I require for this to compare as follows for the above example: compares oct 2024 to january 2024, nov 2024 to feb 2024, and dec 2024 to nothing since in the comparison period only 2 months are selected. However, currently its comparing each month against the total of jany-feb 2024 which is not what i want. Ive tried different work arounds but cant seem to arrive at a solution here. Any help would be appreciated please. Currently im using a second date table and am using an inactive relationship and the following DAX for the comparison period calculations: (sample) pageviews_previous = CALCULATE(SUM(total_pageviews_by_date[screen_page_views]),ALL(dimdate),USERELATIONSHIP(total_pageviews_by_date[date], dimdate2[date]))
Power BI chart interactions
Hi everyone,I am a newbie to Power BI and I have two charts, a line chart and a pie chart. I want to ask how to make the line chart show the information of the week within the date I clicked on the pie chart?For example, if I click on 1/7, the line chart should show the data from 1/1 to 1/7.I have searched many articles but I haven't found what I want. Please help me.
