Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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