Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mukhan169
Helper III
Helper III

Line Chart Continuous Line issue.

LineGraph.PNG

This is how my graph looks after I change the settings. The issue is that the black line is going ober red line and according to business rules It is not possible. We are calculating instances per thousand vehicle and the rule is that 6 months will always have more records then 3 and 12 always ahve more records then 6. By looking at the graph its showing that in 6 months we had more incidents then 12 months. Which is wrong. Is there anyway to create continous line that matches 3  months in service line? I am creating this via table and it is missing those months. MIS.PNG

so basically I asking 2 questions.

1. Is there anyway for the line to continue without crossing any line?

2. if thats not possible then how would I replace the missing months in 6 months of service from 3.

I apologize if I am not clear, pleaase ask for explanation if you need to.

4 REPLIES 4
v-yulgu-msft
Employee
Employee

Hi @mukhan169 ,

 

How is your source table like? Please illustrate the expected result and calculation rule with examples.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

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

MOPMISExplanation.PNG

Thank you for responding 

 

Sum of IPTV by MIS running total in MISGroup =

CALCULATE(
    [Sum of IPTV by MIS]|
    FILTER(
        ALLSELECTED('Claims'[MISGroup])|
        ISONORAFTER('Claims'[MISGroup]| MAX('Claims'[MISGroup])| DESC)
    )
 
 
Sum of IPTV by MIS =
CALCULATE(Claims[IPTV]|
FILTER(values('Claims'[MISGroup])|
COUNTROWS(
FILTER('BinSelect'|
'Claims'[MISGroup]>=BinSelect[minvalueRange]&&
'Claims'[MISGroup]<BinSelect[MaxValueRange]))>0))
)

 

 

 

 

 

IPTV = if(ISBLANK(Claims[ConvertedDataRowCount])|BLANK()|Divide(Claims[ConvertedDataRowCount running total in MIS]|SUM(Sales[SALES])|0)*1000)
 
ConvertedDataRowCount = COUNT(Claims[ID])
 
 
 
ConvertedDataRowCount running total in MIS =
CALCULATE(
    [ConvertedDataRowCount]|
    FILTER(
        ALLSELECTED('Claims'[MIS])|
        ISONORAFTER('Claims'[MIS]| MAX('Claims'[MIS])| DESC)
    )
)

After investigation I think it is more issue of modeling. I have generated a date table that has a relationship to data that is bringing all the records from the transection table.

Relation.PNG

When there is no record for April (as shown in my previous post) for MIS (month is service) 6 it doesnt show the value of April's 3 MIS for the same year. I am not sure how to resolve that.

I am sorry to keep posting but that where it comes down to.

I have a table BinSelect

BinSelect.PNG

I have a column in my trasection table that have 3,6,12 and 24.  I have created one measure 

ConvertedDataRowCount = COUNT(Claims[ID]) 
then tried to do running count so the count of 3 months get added to count of 6 months for each month and year, so January count for 6 MIS is addition to January of 3 MIS and the total of of 6 mis .
For example
3 2017    January   16
and for january of 2017 for 6 MIS has 14 it should show something like
6 2017    January   30 (16+14)
 
it has to go upto 12 and i dont want to do it for 24.
 
I tried to calculate it following way but it doesnt work. Any help will be greatly appriciated.
 
ConvertedDataRowCount running total in MIS =
CALCULATE(
    [ConvertedDataRowCount]|
    FILTER(
        ALLSELECTED('Claims'[MIS])|
        ISONORAFTER('Claims'[MIS]| MAX('Claims'[MIS])| DESC)
    )
)
If someone can help me resolve that will be greatly appriciated.
 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.