Skip to main content

    Power BI

    New

    Conditional formatting for dimensions

    Vote (48) Share
    Mike H's profile image

    Mike H on 29 Sep 2016 17:22:15

    It’s good that you added it, but it’s really some basic alpha-beta level only, in my opinion. It should enable the users to conditionally-format also the dimensions (Attributes) and not only measures (Metrics).

    For example I have got a report with Revenue $ by region (AMER / EMEA / APJ) and i want the colors of the whole row / column / field to be cahnged based on the Region dimension OR Revenue measure).
    Today, we can do only set up a simple conditions to measures.

    Comments (7)
    Mike H's profile image Profile Picture

    ad77ed6e 195e-4bdc-b71b-243b337e8177 on 05 Jul 2020 23:35:23

    RE: Conditional formatting for dimensions

    This is critical in many matrices and graphics

    Mike H's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:27:29

    RE: Conditional formatting for dimensions

    I agree.. this helps in elevating conditional formatting abilities for power bi.

    Mike H's profile image Profile Picture

    1f005402 a260-4251-9dbb-81c8278b6b18 on 05 Jul 2020 23:24:12

    RE: Conditional formatting for dimensions

    Yes, this would be helpful.

    Mike H's profile image Profile Picture

    6c6ca30a 7bb0-4104-bccb-175ff8577647 on 05 Jul 2020 23:23:59

    RE: Conditional formatting for dimensions

    I think this is a good idea and will be helpful

    Mike H's profile image Profile Picture

    38bcb80e 9f6d-410f-a8dc-7d54e5fb957c on 05 Jul 2020 22:49:16

    RE: Conditional formatting for dimensions

    yes, that would be great.

    Mike H's profile image Profile Picture

    0fb19565 a715-4db7-94b3-a6ec0f46464a on 05 Jul 2020 22:48:01

    RE: Conditional formatting for dimensions

    Yes, This would be nice, E.g Based on a measure value we should be able to conditional format the text with in the dashboard

    Mike H's profile image Profile Picture

    307f7a11 88c4-4e46-a376-acfa04c88a15 on 05 Jul 2020 22:45:46

    RE: Conditional formatting for dimensions

    Yes, please add conditional formatting for dimensions (Text). We often have business logic that is applied during ETL and stored in the fact or dimension table, and being able to do conditional formatting like in Excel on text values would be very useful.