cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
afcamacho Regular Visitor
Regular Visitor

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

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

 

 

pantallazo.png

 

I downloaded the KPI from this link : Power KPI

 

How to graph all the dataset in the Power KPI?

 

4 REPLIES 4
Community Support Team
Community Support Team

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

Hi @afcamacho 

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

 

afcamacho Regular Visitor
Regular Visitor

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

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

 

dataset panttallzo.png

 

 

 

Community Support Team
Community Support Team

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

Hi @afcamacho 

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

1.png

 

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.

afcamacho Regular Visitor
Regular Visitor

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

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?

 

 

pantallazo.png

 

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors