Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
The goal is to conditionally format a measure (background color) depending on selected filters.
Constrains, all data dim and fact are in one table.
In order to get to my final measure i had to create some nesting first:
With conditional formatting of % of Vuln
Now my problem starts when i try to filter report by department (also as a part of same table)
I seek for a measure that upon selection will calculate results to 100% for all severities, not only filtered part of data:
I can achieve this result by using Number of Vuln day measure and showing calculation by "Percent of column total", but then logic used to conditionally format fields won't apply.
Lastly, measure for conditional formatting:
and showing calculation by "Percent of column total", but then logic used to conditionally format fields won't apply
Correct. you will need to implement that logic inside your measure.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
25 | |
12 | |
11 | |
10 | |
6 |