Power KPI doesn't show all values in the x axis

[Anonymous]

Hi,

I have been using Power KPI to show data in two Y axis as a "Line chart" but when I try to graph all the dataset in the Power KPI, It only shows a range of two days and the other charts do show the full data; the dataset has data of every 4 seconds

I downloaded the KPI from this link : Power KPI

How to graph all the dataset in the Power KPI?

[v-juanli-msft]

Hi @Anonymous 

What expected visual would you like?

Could you show an example dataset?

Here is a video you could refer to

https://www.youtube.com/watch?v=1enze8pcGzY

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft 

I need to graph two variables in a line chart with independent axis, the unique chart that I saw that allow graph two variables is the Power KPI but when I put all the data of the dataset it only shows two days, the data in the dataset is every four seconds. I also tried the Combo Chart but one of the variables have to be shown as a column.

This is an example of the dataset, the tstm field is the x axis

[v-juanli-msft]

Hi @Anonymous 

Here is a video how to create line charts with 2 y axis using R visuals.

R Visuals in Power BI - Dual Y-Axis Line Chart

In addition, here is an ducument "Create Power BI visuals using R" you could refer to for more details.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi again @v-juanli-msft ,

I also tried using R visual but, I can't interact with the data, there is no a line that give the value of the data like in the line chart, and this line is indispensable to know what happened. Is there any other way?