Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @glawberc
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |