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.
Hello i have the follwoing table:
Status | Campaign type |
Completed | A |
Completed | A |
Completed | B |
Completed | R |
Completed | D |
Completed | A |
Cancelled | F |
Cancelled | GS |
Cancelled | GS |
Cancelled | W |
Cancelled | E |
Cancelled | T |
Cancelled | U |
Cancelled | W |
Cancelled | HG |
Cancelled | SF |
Cancelled | AS |
Cancelled | YF |
Paused | A |
Paused | N |
Paused | N |
Paused | J |
Running | L |
I want to create a dashboard of seperate cards to give me the count of each status , then i want to conditional format the campaign type to a color for each status i asign.
I appreciate the help
Solved! Go to Solution.
Hi @eliasayy .
Create a measure for count as ;
CountCompleted=CALCULATE(COUNTROWS(TABLE),FILTER(Table'[Status]="Completed")
In the same way you can create count of all other status and put them inside cards.
In format pane, you will see option for conditional formatting.
Let me know if that helps.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
Hi @eliasayy .
Create a measure for count as ;
CountCompleted=CALCULATE(COUNTROWS(TABLE),FILTER(Table'[Status]="Completed")
In the same way you can create count of all other status and put them inside cards.
In format pane, you will see option for conditional formatting.
Let me know if that helps.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
Thank you! but how to format the campaign based on the staus value?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |