11-12-2016 06:43 AM - last edited 01-09-2017 11:14 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGood 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
Please share Power BI file if possible. Thanks
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!!
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
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!
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
Proud to be a Super User!
Check out my blog: Power BI em Português