Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys
I'm trying to do something somehow easy but it seems like is not possible in Power BI (Jan 2020 release). I'm trying to display a help message (on a tooltip) based on column the user is hovering into.
There are two different measures (Fixed and Available) and a dimension (Type) used in order to achieve this
I want to display text when user hovers on a cell (column based):
I'm trying with this DAX expression in order to determine whether I'm in Fixed or Available column
Tooltip Text =
VAR selectedType=SELECTEDVALUE(Types[Label], BLANK())
VAR selectedMeasure=SELECTEDMEASURENAME()
RETURN
IF(selectedType<>BLANK(),selectedType, "Nothing")&" Measure: "&selectedMeasure
But I get error "There is no measure reference in the current context that can be used by SELECTEDMEASURENAME", I read about calculation groups and is not what I'm trying to do here but have no other clue on how to achieve this.
Could you please give me an idea on how to create such a tooltip?
Thanks
Solved! Go to Solution.
Hi , @cristianpark
Try steps as below:
1.create a table contain a column as below
2. Then create measures "value" (to instead the field "fixed" and "available") ,and put it into the value of matrix
Value = SWITCH(SELECTEDVALUE('Column'[Column]),"Fixed",AVERAGE('Table'[Fixed]),"Available",AVERAGE('Table'[Available]))
3.create page3 as tooltips page ( make sure the type of tooltip is report page)
Put measure "tooltip text" into a card visual in page3
Tooltip Text =
VAR selectedType=SELECTEDVALUE('Column'[Column], BLANK())
RETURN
IF(selectedType<>BLANK(),selectedType, "Nothing")&" Measure: "&[Value]
4. it will show as below
Here is a demo .
In addition , you can refer this post if help.
https://community.powerbi.com/t5/Desktop/Can-I-have-a-tooltip-per-entry-to-a-table/td-p/928605
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @cristianpark
Try steps as below:
1.create a table contain a column as below
2. Then create measures "value" (to instead the field "fixed" and "available") ,and put it into the value of matrix
Value = SWITCH(SELECTEDVALUE('Column'[Column]),"Fixed",AVERAGE('Table'[Fixed]),"Available",AVERAGE('Table'[Available]))
3.create page3 as tooltips page ( make sure the type of tooltip is report page)
Put measure "tooltip text" into a card visual in page3
Tooltip Text =
VAR selectedType=SELECTEDVALUE('Column'[Column], BLANK())
RETURN
IF(selectedType<>BLANK(),selectedType, "Nothing")&" Measure: "&[Value]
4. it will show as below
Here is a demo .
In addition , you can refer this post if help.
https://community.powerbi.com/t5/Desktop/Can-I-have-a-tooltip-per-entry-to-a-table/td-p/928605
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi there,
By chance you still have the .pbix file? seems to be gone
Thank you @Greg_Deckler and v-easonf-msft for such complete answers.
Bookmarks approach @Greg_Deckler proposed is an easy way to do it without affecting underlying data model (the default option for us was just to put help text below table so bookmarks are a good addition to it).
Creation of table as v-easonf-msft is cool, that way you can customize tooltip as needed and is more scalable modifying value measure for adding columns with custom tooltip. The only caveat I saw is that you'll loose ability of sorting by each column on matrix and in my case, that's a must.
It'll be great to be able to somehow identify a measure within a cell but workarounds are good enough for now.
Thank you!
Well here is one way that I recently came up with (attached). I'll see if I can come up with anything better.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |