Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello guys, it's me one more time.
Today i got a problem and i'd like to ask you for help. Happens that i've made a table with the status of stages in my project [1 to 5] and made another column to count how much projects are in this status within that stage.
This value is calculated by a measure that filters the status and the stage.
I've made a tooltip with my projects name in a way that i could hover my mouse above the status number and have the name of that project with that status in that stage. In this case i have 1 delayed project [red light] in the stage Buying.
So the tooltip is made but when i hover my mouse it gives me the list of all projects within that status number in all stages, there's some kind of way to maintain my stage filter in the tooltip.
PS: The only way i filter the stage is by the measure below.
1 Cont Buying =
VAR _A =
CALCULATE(
COUNTROWS( 'Table1' ),
FILTER(
'Table 1',
YEAR('Table1'[Date Conc]) <= 2022
&& 'Table'[Stage] = "Buying"
)
)
RETURN
IF( ISBLANK( _A ), 0, _A )
Hi @Anonymous
I believe you should find your answer here
https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
Have a great day!
Thanks for the help @tamerj1, unfortunately it didn't worked as the way i needed. Still looking for a resolution yet, apperently it will be more hard than i thought.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |