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 ...
Need Help
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.