Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PijushRoy
Super User
Super User

Tooltip is not filtered when hover on measures

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

OrderStatusOpen = CALCULATE(COUNT(Order_Data[Status]),FILTER(Order_Data,Order_Data[Status]="Open"))
OrderStatusClosed = CALCULATE(COUNT(Order_Data[Status]),FILTER(Order_Data,Order_Data[Status]="Closed"))
TotalOrderNumber = COUNT(Order_Data[Status])
and create the below chart
001.png
Notes - I am not able to use Yaxis or Legend
Now I need to show Invoice Value in tooltip
When I am showing tooptip, the filter as per Bar is not working
PBIX file attached
002.png003.png
 
Any thinking, please suggest

Notes - I also tried to implement the Custom Data level (as features)



Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





1 ACCEPTED SOLUTION
Anonymous
Not applicable

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]
)

vrongtiepmsft_0-1686707049260.pngvrongtiepmsft_1-1686707066456.png

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.

View solution in original post

4 REPLIES 4
Contactkpatel
New Member

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).  

 

Contactkpatel_0-1712669529647.png

 

Anonymous
Not applicable

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]
)

vrongtiepmsft_0-1686707049260.pngvrongtiepmsft_1-1686707066456.png

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





PijushRoy
Super User
Super User

In Chart, Left hand side we can show the name
Order Open
Order Closed
Total Order




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors