Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
In my dataset, I have several date columns. So I created a Calendar to make relationships with the dates. Since I can only make 1 date that is active relatoinship, I created inactive relationships with the other dates. Then I used dax Userrelationship formula to make measures to sum the $ total and reference the calendar date and my data table dates.
I used conditional formatting in my matrix table to check if the invoice has been made, then color the background of the $ amount to be green.
I have a date filter that the user can use to see when the invoices were made or will be made.
Without any date filters used, the matrix table looks correct. However, when a date is selected, the green background formatting doesn't work. It only works for the 1 date that I have an active relationship with the Calendar table. All ther other columns do not work correctly.
Below is an example of my data table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.