Card visual is showing blank but matrix is showing value in power bi
Hi i have a card visual and a matrix visual, along with that i have a date slicer (between). scenario: when the date slicer changes the value in the card and well as matrix gets adjusted to the last date in the date slicer. matrix has categories(category column) as a row. Card visual is showing the over all values without the category. problem: for few dates, there are few category missing. When i slelect those dates , card visual does blank, but matrix visual shows value for which the category is present for that day and blank for the category which is not present for the day, shown below. Card visual should show values of 3 of the above category but it just showing blank. Below is the calculation measure for card visual: please give me a solution
Running Total from Current Month Onwards
Hi Everyone, I am trying to compute running total of outbound quantity with additional conditions: Cumulative quantity starting from the first date of current month up to any dates in the future Filter context on date is expected to be from March 1st up to June 30th, 2024. I have tested with 2 measures below and they still haven't met the business requirements. The former here is adding up cumulative quantity way back to December 2022, and this is indeed not what we are after: Outbound RT = VAR MaxDate = MAX ( 'DATE'[Date] ) RETURN CALCULATE ( [Outbound], 'DATE'[Date] <= MaxDate, ALL ( 'DATE' ) ) Whereas, this is starting to add up cumulative quantity from "Today" onwards, meaning that any outbound before current date are not factored in as part of calculation: Outbound RT 2 = VAR MaxDate = MAX ( 'DATE'[Date] ) RETURN CALCULATE ( [Outbound], 'DATE'[Date] <= MaxDate && 'DATE'[Date] >= TODAY(), ALL ( 'DATE' ) ) Expected Results: DAX code that starts computing from the first day of current month (March in this stance) onwards to any future dates. The code should add up cumulative quantity starting from March 1st, 2024. Is there anyone who can guide me through? Thank you so much!
Default selection of the most recent date in Power BI slicer after dataset refresh
Hello All, I've a date dropdown filter (with single selection) and I want to set its default value to the most recent date after every refresh. I've researched a lot about this but couldn't find any perfect fit, I've tried below code as well Date 2 = IF('Table'[Date] = MAX('Table'[Date]), "Recent Date", FORMAT('Table'[Date], "MM-DD-YYYY")) but the problem is I don't want a plan text "Recent Date", so I tried to append Recent Date as text along with the text "Recent Date" e.g., "Recent Date 04/04/2023" but in that case after refresh I got 2 values (Previous latest date and the current one after refresh) and so I've to again manually change the date from the dropdown, see below for reference. IF('Calender table'[Date] = MAX('Calender table'[Date]),CONCATENATE("Recent Date ", (FORMAT('Calender table'[Date], "MM/DD/YYYY"))),FORMAT('Calender table'[Date], "MM/DD/YYYY")) If anyone have any solution then please help me out with this, Thanks, Dinky
