Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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]))
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |