cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blitwak Frequent Visitor
Frequent Visitor

Create a compound chart using a line chart and a KPI

Hi,

I want to create a compound chart using Power BI but I don't find a visualization that help me.

I want a line chart with a KPI like the following example

Thanks

 Example

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-viig
Moderator

Re: Create a compound chart using a line chart and a KPI

Hi @blitwak,

 

Power KPI custom visual is what you are looking for because it can be customized pretty close to what you need.

You can download it from AppSource: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381083

 

image.png

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

8 REPLIES 8
Moderator v-viig
Moderator

Re: Create a compound chart using a line chart and a KPI

Hi @blitwak,

 

Power KPI custom visual is what you are looking for because it can be customized pretty close to what you need.

You can download it from AppSource: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381083

 

image.png

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

blitwak Frequent Visitor
Frequent Visitor

Re: Create a compound chart using a line chart and a KPI

Thanks!

One more question!

Now, it shows value from last week (2019w26).

If I want to show current week value (2019w07), How can I do it?

 

Highlighted
blitwak Frequent Visitor
Frequent Visitor

Re: Create a compound chart using a line chart and a KPI

I understand that I can use filter by week , filter type as 'top N', and show items with the number... but I want that number change every week.. Is it possible?

Moderator v-viig
Moderator

Re: Create a compound chart using a line chart and a KPI

Not sure if I understand the requirement well.

 

Can you share a screenshot to understand it better?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

blitwak Frequent Visitor
Frequent Visitor

Re: Create a compound chart using a line chart and a KPI

I need to show every week the last value from a metrics.

For example,

The first week, from week 1 to week 10.

A new week arrives, so one more week: from week 1 to week 11.

Is it possible in Power BI? 

 

Another question, 

Is it possible when having a stacked column chart, when resting over a column, show all the values from the different groups from that stacked column? It shows just the value from the group that you rest

Moderator v-viig
Moderator

Re: Create a compound chart using a line chart and a KPI

Not sure if it's possible in Power BI.

 

I suggest to ask these questions in Desktop forum because they know PBI better in terms of data manipulations.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

blitwak Frequent Visitor
Frequent Visitor

Re: Create a compound chart using a line chart and a KPI

Thanks.

I also want a table that adds automatically new dates (columns). Always the same rows.

Do you know if it is possible?

For instance, always the same 4 metrics as rows but adding yesterday' values.

 

Moderator v-viig
Moderator

Re: Create a compound chart using a line chart and a KPI

I think it's feasible if data is updated. So, any visual can take the latest date from the data set and show it.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com