How can we improve Power BI?

KPI Icon sets for use in table and matrix visualizations

Many of the Power BI Community have come from a background of using Power Pivot in Microsoft Excel. Excel had a fantastic way of using built-in conditional KPI icon functionality to add impact and information to table and matrix visualizations. The red-yellow-green circle icon set is valuable as an easy-to-interpret indicator of whether something is on track (or not) against defined goals.

This functionality is glaringly absent from the Power BI Desktop. There was a previous request for tis that has been marked as “completed”, but it’s still missing.

429 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    20 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Paul TurleyPaul Turley commented  ·   ·  Flag as inappropriate

        The KPI feature has been a standard in SSAS and Excel for many years. I was surprised that it wasn't part of Power BI from the beginning. I'd also like to have the option to calculate the Status and Trend properties separately, like we can in SSAS but just tie them to a hidden measure (e.g -1, 0, 1)

      • Anonymous commented  ·   ·  Flag as inappropriate

        Creo que sería un agregado de suma utilidad poder incluir caracteres gráficos como datos de una tabla ... para ello quizás alcance con poder utilizar otra tabla de caracteres, por ejemplo, Wingdings.

        Muchas gracias por la atención !!!

        Dany

      • Malcoim SankohMalcoim Sankoh commented  ·   ·  Flag as inappropriate

        Just noticed the absence of this feature for matrix/tables in Power BI. Conditional KPI icons is a highly and urgently needed feature.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is high on my wish list - We need this for Power BI report representing project health indicators in a data set connected to Project Online - currently we just show a Text (On Track) - which isn't that cool...

      • Anonymous commented  ·   ·  Flag as inappropriate

        Excel had a fantastic way of using built-in conditional KPI icon functionality to add impact and information to table and matrix visualizations. The red-yellow-green circle icon set is valuable as an easy-to-interpret indicator of whether something is on track (or not) against defined goals.
        This functionality is absent from the Power BI Desktop. There was a previous request for tis that has been marked as “completed”, but it’s still missing.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Excel had a fantastic way of using built-in conditional KPI icon functionality to add impact and information to table and matrix visualizations. The red-yellow-green circle icon set is valuable as an easy-to-interpret indicator of whether something is on track (or not) against defined goals.
        This functionality is glaringly absent from the Power BI Desktop. There was a previous request for tis that has been marked as “completed”, but it’s still missing.

      • JohnJohn commented  ·   ·  Flag as inappropriate

        Any update?

        I could migrate 3 Excel Power Pivot dashboards to Power BI if I had this feature today.

        Please let us know if this is coming out any time soon...

      • Anonymous commented  ·   ·  Flag as inappropriate

        Currently the custom visual of infographics kinda do this, but sure is a little cluncky, getting this kind of customisation surely makes the visual more confortable to nom-analytical viewers

      • EstebanEsteban commented  ·   ·  Flag as inappropriate

        I agree. This would be great. I more great would be if you can custom the KPI icon.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We use this a lot with SSRS and also even PerformancePoint, and we would like to swap out PerformancePoint with PowerBI.

      • Xavier RoviraXavier Rovira commented  ·   ·  Flag as inappropriate

        The problem is even worst. I started my model few months ago in PowerPivot, using KPI functionality. I migrated it to PowerBi due to severe performance problem, and continue its development in PowerBI. The migration tool was great in migrating the KPI functionality and it creates like a "group calculated field" with three Childs: Value, status, goal. Great!!!

        Now the problem I face is I cannot create new ones

      • Miguel GallardoMiguel Gallardo commented  ·   ·  Flag as inappropriate

        I totally agree. This is a great functionality in PowerPivot that PoweBI is missing!

        I hope you can add it soon!

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.