The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
HI Team,
I have sample data with below format
Customer_ID | Value | Status |
DBA00001 | 17640 | Closed |
MSU00001 | 5040 | Closed |
DAA00002 | 35406 | Open |
DAA00002 | 30450 | Hold |
DGO00002 | 6300 | Open |
MSU00001 | 26250 | Closed |
I need to show Count of Open Order, Count of Closed order and Total number of order in Clustered Bar Chat
So I have three measure
Proud to be a Super User! | |
Solved! Go to Solution.
Hi @PijushRoy ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
SWITCH(
SELECTEDVALUE('Order_Data'[Status]),
"Open",[OrderStatusOpen],
"Closed",[OrderStatusClosed],
[TotalOrderNumber]
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I know this post is an old "solved" post. But for future reference, though the original solution is brilliant, I think we are over complicating this particular situation. Just put "count of value" in X-axis and "status" as legend (as shown in pic below).
Hi @PijushRoy ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
SWITCH(
SELECTEDVALUE('Order_Data'[Status]),
"Open",[OrderStatusOpen],
"Closed",[OrderStatusClosed],
[TotalOrderNumber]
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @Anonymous
Working fine.
I am trying to use SelectedValue, SelectedMeasure in tooltip page to filter the data, wrong idea.
You make it very efficient way. New learning for me.
Thanks again
Pijush
Proud to be a Super User! | |
In Chart, Left hand side we can show the name
Order Open
Order Closed
Total Order
Proud to be a Super User! | |