Power BI Matrix Columns

SonyaNadesan — Sun, 09 Feb 2025 16:49:41 GMT

I have a matrix that shows data for the selected month.

However, the requirements has changed - the user would like to select a specific date, for which the data for the past week is displayed in our matrix.

How can I achieve this, given that I cannot drop a measure into the Columns section of the matrix?

Re: Power BI Matrix Columns

bhanu_gautam — Mon, 10 Feb 2025 06:23:58 GMT

SonyaNadesan ,

Create a measure to capture the selected date from a slicer.

SelectedDate = SELECTEDVALUE('DateTable'[Date])

Create a measure to calculate the data for the past week based on the selected date.

PastWeekData =
CALCULATE(
SUM('YourTable'[YourDataColumn]),
DATESINPERIOD('DateTable'[Date], [SelectedDate], -7, DAY)
)

Add the date column from your date table to the Columns section of the matrix.

Add the PastWeekData measure to the Values section of the matrix.

topic Re: Power BI Matrix Columns in DAX Commands and Tips

Power BI Matrix Columns

Re: Power BI Matrix Columns