Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Disable SEE RECORDS

Hi guys,   I looked for a solution to hide/disable the option SEE RECORD. I must prevent users to right-click > See Record because they are not allowed to see the raw data.   Some posts in the we...
  • parry2k's avatar
    5 years ago

    Anonymous First of all there is no performance issue if you create an explicit measure and as mentioned, as a best practice you want to explicit measure (make a habit of it), may be this report has only 1-2 visuals/pages but think about the bigger picture, if you are working on a larger project, complex reports, etc, having implicit measure will be a nightmare, it is more about following the best practice and making a habit.

     

    Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • edhans's avatar
    5 years ago

    Anonymous imagine the following scenario:

    1. You need to create a visual that shows sales, so you drag the sales field into your visual. It works.
    2. You create 3 visuals that use this method, and conditionally format one of them as a matrix with bars on the values.
    3. Your boss comes in and says "We actually need to know what the gross collections are, so please include sales tax in your visuals.
    4. You now have to create an explicit measure that is SUM(Sales[Sales]) + SUM{Sales[Sales Tax]), then remove all of your implict measures, add this new measure in, and redo any conditional formatting.

    Had you created the explict measure to start with = SUM(Sales[Sales]) the only thing you would have had to do is edit the measure to the new formula, and all visuals everywhere would automatically update.

     

    Also, you cannot create pivot table in Excel that use implicit measures when you use the new connect to Power BI dataset. It currently only allows you to add explicit measures to value fields.

     

    As parry2k indicated, this isn't really right or wrong, but best practice. Your future self will thank you for it.