Conditional formatting for matrix column headers based on closed month
Hi all, I am working with a Power BI matrix where I have months (January–December) displayed as column headers, as shown in the screenshot. no value will display, only the column Kindly ask for below request solution Dynamically change the background color of the column headers If a month is financially closed → show green If a month is still open → show grey I have a DAX in my model (e.g., a measure or flag indicating whether a month is closed): Closed Month Flag = IF( SELECTEDVALUE('Time'[IsClosedMonth]) = TRUE(), 1, 0 ) so the challenge is only related to applying the formatting to the headers. Thanks for support!
Sorting Data in Different Order Based on Slicer Selection in Power bi
Hi Everyone, I want to sort the data in a specific order. When I select a value in the slicer. Below is the raw data: Table : Year Month Product Amount 2023 1 AA 100 2023 2 BB 200 2023 3 CC 100 2023 4 DD 100 2023 5 EE 300 2024 1 AA 300 2024 2 CC 500 2024 4 DD 600 2024 5 ZZ 300 2024 6 BB 300 slicer : order Required The order in which the products need to be sorted, when we select the year from slicer.Sorting Matrix Data Based on Slicer Selection
Hi Everyone, I want to sort the data in a matrix in a specific order. When I select a value in the slicer. Below is the raw data: The matrix visual contains Product and Value [Measure]. Raw Data Slicer The order in which the products need to be sorted depends on the year value selected in the slicer. Raw Data : Table Product Year Value P3 2023 100 P2 2023 200 P1 2023 300 P8 2023 40 P6 2023 100 P1 2024 200 P3 2024 300 P2 2024 40 P14 2024 100 P12 2024 200 slicer : Year 2023 2024 Required order, when we click on slicer : Order Required 2023 2024 Order order P1 P1 P2 P2 P3 P3 P6 P12 P8 P14
Conditionally format the row header of a matrix chart
How do I conditionally format the row header of a matrix chart in Power BI? I have a matrix chart where: In "Lines" I inserted the data from two columns of table 1. (Ex: Columns: A and B) In "Columns" I inserted another column from table 1 (Ex: Column C) and a column from table 2 pulling the months (Ex: Column D). In Values, insert the sum of two columns ( E and F ) from table 1. I want to format all the lines, both the header lines and the value lines so that whenever the word "total" appears, the background color changes. I was able to do this in the value fields by inserting a measure in the "conditional formatting" option using this DAX formula: "Format 1 = IF(CONTAINSSTRING(SELECTEDVALUE(TABLE1[COLUMN A]), "TOTAL"), "#CCCCCC", BLANK())" But I'm not able to format the line headers this way. All the tutorials I see are related to column formatting, column headers and values...
Matrix with drill down : Display certain rows based on slicer selection
I have a matrix table with level 2 , level 3 and level 4 in rows with drilldown option enabled, (Expand to next level using +icon) and product in column and Total in values, added a columnn BG in slicer. The ask is : If i select value A from the slicer i want level 2 and level3 values should display and level 4 should not be displayed in the matrix row. Level 2 should drill down to level 3. If i select value B from the slicer i want level 3 and 4 should display and level 2 should not be displayed in the matrix row. Level 3 should drilldown to level 4. Quick Snapshot of the visual. Please help me. Any solution with calculated columns or measures works
