Create a compound chart using a line chart and a KPI

[blitwak]

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

 

[v-viig · Accepted solution]

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[blitwak]

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?

[blitwak]

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?

[v-viig]

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]

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

[v-viig]

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]

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.

[v-viig]

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