Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am having issue to use measure in chart , filter visuals. Measure is giving me the correct result but I need to use it as bar chart, how to convert measure to calculated column.
How can I use this measure in a bar chart to show number of items in respective status
Thanks for responding.
I have individaul measures where the calculation has been done and then there is a "Overall Status" measure where I am using Switch to use individual measures to return the result.
Hi @Chaithrar
You can refer to the following solution.
1.Put the status to a new table
e.g
2.Then create the measure
e.g
Switch_measure =
VAR a =
ADDCOLUMNS (
'Table (2)',
"judge",
SWITCH (
TRUE (),
[Sum] >= 10
&& [Sum] < 40, "a",
[Sum] >= 40
&& [Sum] < 60, "b",
[Sum] >= 60, "c"
)
)
RETURN
COUNTROWS ( FILTER ( a, [judge] IN VALUES ( 'Table'[Type] ) ) )
3.Put the status and measure to the related visual
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |