Creating a Dimension that is dependent on Parameter Selected
Hello, I am transitioning from Tableau to Power BI and am Struggling finding DAX Expressions that allow the rows/columns in a Matrix to adjust based on the parameter selection. In Tableau this was a simple task because I could just write the calculated field below. Aging Days if [Aging Parameter] = "DOS Aging" Then [DOS Aging] elseif [Aging Parameter] = "Denial Aging" then [Denial Aging] END Aging Group CASE [Aging Days] WHEN "000 - 030" THEN "000 - 090" WHEN "031 - 060" THEN "000 - 090" WHEN "061 - 090" THEN "000 - 090" ELSE "091 +" END How can I create a new Column that groups the days based on the Parameter Selection in a Matrix? No Matter which Aging Parameter is selected the Grouping is the same but the Aging Days will vary based on which selection is made (DOS or Denials). Thank You in advance for your help!
Issues conditional formatting coloring with a sum of measures
Hi community, I have been working on this visual for some time now. I’ve had members help me along the way which has saved me greatly. I am having issues with implementing conditional formatting on a bar chart depending on measures - I have been trying to create a type of bar chart where each bar may be coloured depending on measures. This is how the bar chart looks like: I have used this for conditional formatting: Conditional Formatting Measure = Switch(TRUE(), SELECTEDVALUE('Aggregate'[PerformanceLevel]) = "Meets " && [Meets%]+[Exceeds%] > 90, "orange", SELECTEDVALUE('Aggregate'[PerformanceLevel]) = "Marginal" && [Marginal%] + [Below%] > 40, "yellow", SELECTEDVALUE('Aggregate'[PerformanceLevel]) = "Exceeds" && [Exceeds%] > 30, "green", SELECTEDVALUE('Aggregate'[PerformanceLevel]) = "Below" && [Below%] > 15, "red", "grey") When there is a sum used in the condition, the bar does not change colour – the sum is not taken into account. I have many instances where Marginal+Below>40 and Meets+Exceeds>90 but the bar doesn't change colour. Here is a link to a sample workbook: google drive I would really appreciate any help and guidance on this. I don't understand why the sum is being ignored.
