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 community,
I am trying show the parameter field in a dynamic tooltip in a matrix, but when I used selected value or selected measure the tooltip show me blank.
This is my structure of my matrix
I used the option of show values in a row.
This is my parameter:
The tooltip always show me blank
Any ideas why can not show the name of measure?
If anyone could help me out it would be highly appreciated,
Kind regards
Solved! Go to Solution.
Thanks for the reply from MattAllington , please allow me to provide another insight:
Hi @lnerii94 ,
You can try to create the following measure to put directly into the Tootip Page:
Test =
MAX('Table 2'[Value1])
Result:
If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from MattAllington , please allow me to provide another insight:
Hi @lnerii94 ,
You can try to create the following measure to put directly into the Tootip Page:
Test =
MAX('Table 2'[Value1])
Result:
If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @Anonymous for your reply, I replicated the logic in my report and it works, Thank you too @MattAllington for your help.
Best Regards.
selectedvalue is used to show a single value in a column after it has been filtered. You are using a parameter. What column are you refering to in your measure? I'm not sure if it can work or not so you will have to test it using the columns from the parameter table. If it doesn't work, you could try IF(HASONEVALUE(ParameterColumnName),VALUES(ParameterColumnName))
Selected value shows blank when there's more than one value to display. You could change your selected value measure to a test measure like this to see what's going on
test = CONCATENATEX(VALUES(Table[Column name]),Table[column name],", ")
instead of showing blank, it will show you the list of values.
It is work to show all the names of the measures in the matrix, but How I can to show only the name of the specific row, for example:
Thanks
User | Count |
---|---|
82 | |
81 | |
36 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |