Forum Discussion

AP14's avatar
AP14
New Member
2 years ago

Power BI Visual to show category performance wrt different KPIs

Hi everyone,

I have several KPIs in my report. Is there a visual to show , how different categories are performing wrt those KPIs?

PFB sample data and the visual I would like to create in Power BI desktop.

 

 

 

Thanks,

AP

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AP14 

     

    Here I create a set of sample data ：

    As you can see, this table does not contain date information, it can only be used for your reference.

    Then I create a measure:

    Measure = 
VAR _currentCagegory = SELECTEDVALUE('Table'[Cagegory])
RETURN 
SWITCH(
    _currentCagegory,
    "A",SUM('Table'[Energy]),
    "B",SUM('Table'[Sales])&"-"&SUM('Table'[Profit])&"-"&SUM('Table'[Energy]),
    "C",SUM('Table'[Energy])&"-"&SUM('Table'[Sales]),
    "D",SUM('Table'[Profit])
)

    The result is as follow:

    Hope this can help.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • AP14's avatar
      AP14
      New Member
      2 years ago

      Hi, Thanks for your reply. However, I don't want the values/measure. I want to show via a visual that whether for a particular time (say year) , the category had a growth or decline of that KPI.

      For ex. , the target may be £100 sales but in Yr 2023 sales was £47 and 2024 its £109. So my visual should show ,upon selecting the year, thae symbol for total sales (£) on 'decline' and 'growth' sides of the visual. And same for other categories wrt to the KPIs. 
      I am not sure if any such custom visual is available or not in Power BI. Hence seeking help.