Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am new to Power BI.
My data set looks like this:
I want my column graph to look like this:
How do I achieve this?
Thanks in advance for all the help.
Solved! Go to Solution.
@Anonymous , No pets on axis and a measure
measure = count(Table[Pets]) on values should do
If you want a table
new Table =
summarize(Table, Table[pets], "Count", count(Table[Pets]))
@Anonymous , This counts pets with pets on-axis.
With conditional formatting measure with field value option
Color = Switch(true(),
max(Table[Pets] ="Cat" , "Red",
max(Table[Pets] ="Dog" , "Yellow",
// Add other
"Green" //default
)
For conditional formatting refer PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Hi @amitchandak ,
But in order to achieve this, I think my data source should look like this:
How do I model it in this way?
@Anonymous , No pets on axis and a measure
measure = count(Table[Pets]) on values should do
If you want a table
new Table =
summarize(Table, Table[pets], "Count", count(Table[Pets]))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
101 | |
97 | |
88 | |
68 |
User | Count |
---|---|
169 | |
133 | |
130 | |
103 | |
95 |