Reply
Frequent Visitor
Posts: 7
Registered: ‎02-08-2019
Accepted Solution

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

 


Accepted Solutions
Highlighted
Moderator
Posts: 1,666
Registered: ‎12-02-2016

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

View solution in original post


All Replies
Highlighted
Moderator
Posts: 1,666
Registered: ‎12-02-2016

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

Frequent Visitor
Posts: 7
Registered: ‎02-08-2019

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?

 

Frequent Visitor
Posts: 7
Registered: ‎02-08-2019

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
Posts: 1,666
Registered: ‎12-02-2016

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

Frequent Visitor
Posts: 7
Registered: ‎02-08-2019

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
Posts: 1,666
Registered: ‎12-02-2016

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

Frequent Visitor
Posts: 7
Registered: ‎02-08-2019

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
Posts: 1,666
Registered: ‎12-02-2016

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