topic Re: Maintenance report in Data Stories Gallery

Maintenance report

MFelix — Mon, 09 Jan 2017 19:14:45 GMT

This is one of my first reports in order to control maintenance costs. This is a very simple version an it was my first full report made about 1 year ago problably a lot of mistakes this as already evolved to other features.

MFelix

eyJrIjoiNjcwMWI2OTctNWZjZi00NTUyLTkzODEtZmQ4YTE4ZDhhNWI5IiwidCI6IjMwNDljMmY0LWNlMWUtNDlkOS1iZTYwLTNiNmFiNDAyODQ0YiIsImMiOjh9

Re: Maintenance report

angova — Tue, 08 May 2018 13:45:32 GMT

Hi MFelix

You have done an excellent work here! I have a question. How do you create the "Top N" filter in the 3rd page? I'm trying to do something like that but I don't know how to do it.

Thanks in advance!

Re: Maintenance report

MFelix — Tue, 08 May 2018 17:46:02 GMT

Hi angova,

Thank you for your compliment.

The Top N is made using a table for the ranking numbers and 3 measures. Currently using the What if Parameter you can create a parameter from 1 to 100 and make it incremental.

Then create 3 measures:

Rank =
RANKX (
    ALLSELECTED ( Table[Column] );
    CALCULATE ( SUM ( Table[ValuesColumn] ) )
)


TOP_N = if ([Rank]<= MAX('TopN'[TopN]);1,0;BLANK())


Top N Total =
CALCULATE (
    SUM ( Table[ValuesColumn] );
    FILTER ( ALL ( Table[Column] ); [Rank] <= MAX ( 'TopN'[TopN] ) )
)

Then Top N Total gives you the total based on the filter by the slicer of the TOP N and the TOP_N measure should be added as a filter (visual or page) and set to Not Blank this will filter out all the results you don't have when choosing the N filter.

Regards,

MFelix

Re: Maintenance report

angova — Wed, 09 May 2018 07:26:36 GMT

Hi MFelix,

That works! Thank you so much.

Re: Maintenance report

anizioneto_ca — Thu, 11 Oct 2018 17:17:37 GMT

Hey MFelix I am amazed by how ease and great to read is this report. Did you make it available in any link? Is there a way to donwload it the way I could play with it?

Thank you for sharing.

Cordially,

anizioneto_ca

Re: Maintenance report

Renata — Tue, 27 Nov 2018 20:59:13 GMT

Hi MFelix! I really love your dash! Is it possible share with me? Layout is so clean!

My email is renatagabardo@gmail.com

Tks and congrats!!

Re: Maintenance report

mahesh009 — Mon, 21 Oct 2019 19:02:00 GMT

Please share Power BI file if possible. Thanks

Re: Maintenance report

Anonymous — Sat, 25 Apr 2020 22:35:19 GMT

Good afternoon Miguel, I love the maintenace report. I have something simliar which is Prevent Maintenace and have issues even Beginning with the Data model any suggestion or can you send me a copy so I can see how you were able to arrange you data table.

lydriarivera@gmail.com.

thank you