The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I want to publish a set of reports to be used in our office (and maybe with some individuals outside our office). I don't want users to be able to slice down to a level which would show them the data for a single record, as individual information is sensitive. So, what I want is a "check" after a slicer is used to ensure that at least 5 records are present before the aggregated results are displayed. If a slicer reduces to n<5 I just want reports to be blank.
@ARichman wrote:
I want to publish a set of reports to be used in our office (and maybe with some individuals outside our office). I don't want users to be able to slice down to a level which would show them the data for a single record, as individual information is sensitive. So, what I want is a "check" after a slicer is used to ensure that at least 5 records are present before the aggregated results are displayed. If a slicer reduces to n<5 I just want reports to be blank.
I'd aggregate the dataset when loading, say aggreate the data via Power Query or via SQL Query when data is from database end.
Hmm, if it was just one value, you could use HASONEVALUE function. For < 5, perhaps you could create a measure that counts the number of records involved but you would likely need a custom visual to take such a thing into account. Will noodle on it.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
100 | |
81 | |
62 | |
54 |
User | Count |
---|---|
250 | |
119 | |
115 | |
95 | |
70 |