Forum Discussion
Complex Conditonal Formatting
Hi chriswoodiow ,
Thanks again for the followup!
I tried to recreate on my local.Please follow the below stesp:
1.Created a separate calender table and created relationship between Calender table and Fact table.
2.Create a new measure for icon selector using below:Icon Selector =
VAR CurrentMonthData = CALCULATE(
MAX('FactTable'[BuildingShipColumn]),
ALLEXCEPT('Calendar', 'Calendar'[Month])
)
RETURN
SWITCH(
TRUE(),
ISBLANK(CurrentMonthData), -1, -- No data case
CurrentMonthData = "Building", 1,
CurrentMonthData = "Ship", 2,
BLANK()
)3.Add a dummy measure as it ensures the visual renders rows even when there’s no data in FactTable.
Then add a table visual from Calender[Month] and dummy measure to the table.
4.Apply conditional formatting.To apply conditional formatting with icons in Power BI, select the table visual, click the Dummy column under Values, then go to Visualizations > Format Visual > Cell elements. Choose Dummy, toggle on Icons, set Format style to Rules, and pick the Icon Selector measure. Add rules: -1 for "No icon", 1 for "Building" (house), 2 for "Ship" (boat). Set Apply to as Values only, then close the pane.Select the icons as per your requirement.Ensure "Show Items with No Data" Is Enabled for Calender[Month]column.
5.Now select the slicer visual and add Calender[YearMonth].
Please refer the screenshot and file for your referenceIf this asnwer meets your requirement,give us kudos and consider accepting it as solution.If still facing in resolving ,feel free to reachout!
Thank you.
Regards,
Pallavi G.
At the moment, you can only get one icon per cell (using the default settings). If you want to have two icons, then you will need to create your own icon(s) - like the following: https://jihwankimcscp.wixsite.com/supplychainflow/post/enhancing-power-bi-custom-themes-with-new-icons
Then you can use a switch statement to map the icon to your conditions:
Conditional Format Measure = SWITCH(TRUE(),
condition1, 1,
condition2, 2,
... etc.
)
Once you apply the icons, you can change the Rules section to
If value = 1 Number then (your custom icon)
...
If value is blank then No Icon