skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Maintenance report

    Maintenance report

    11-12-2016 06:43 AM - last edited 01-09-2017 11:14 AM

    Super User MFelix
    Super User
    12253 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    MFelix
    Super User MFelix
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Maintenance report

    ‎11-12-2016 06:43 AM

    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


    Regards

    Miguel Félix


    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

    Check out my blog: Power BI em Português



    Preview file
    90 KB
    Labels:
    • Labels:
    • Business
    Message 1 of 8
    12,253 Views
    7
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-25-2020 03:35 PM

    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

    Message 8 of 8
    5,201 Views
    0
    Reply
    mahesh009
    mahesh009
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-21-2019 12:02 PM

    Please share Power BI file if possible. Thanks

    Message 7 of 8
    6,284 Views
    0
    Reply
    Renata
    Renata
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-27-2018 12:59 PM

    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!!

    Message 6 of 8
    8,352 Views
    0
    Reply
    anizioneto_ca
    anizioneto_ca
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-11-2018 10:17 AM

    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

    Message 5 of 8
    8,647 Views
    1
    Reply
    angova
    angova
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-08-2018 06:45 AM

    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!

    Message 2 of 8
    9,318 Views
    0
    Reply
    MFelix
    Super User MFelix
    Super User
    In response to angova
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-08-2018 10:46 AM

    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


    Regards

    Miguel Félix


    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

    Check out my blog: Power BI em Português



    Message 3 of 8
    9,311 Views
    2
    Reply
    angova
    angova
    Frequent Visitor
    In response to MFelix
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-09-2018 12:26 AM

    Hi @MFelix,

     

    That works! Thank you so much.

    Message 4 of 8
    9,298 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices