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 Power BI Community
I'm having some trouble in being able to generate a tooltip with multiple fields (with values summed and sorted in descending order). I have included a data sample to assist with the explanation:
- two tables (tblBank and tblStats)
- linked by means of a transaction code
- company will be bought by multiple banks
- needing to produce a report as follows
Company Name Date Banks
------------------------------------------------------------
Company X Dec-18 Bank 4, Bank 2, Bank 1
Tooltip to provide fee paid per bank, ie. Bank 4 - 400
I'm hoping this makes sense, but I'm pulling my hair trying to get this resolve.
Thank you in advance.
Solved! Go to Solution.
Hi @diederd ,
Create 3 dimension tables:
This tables will have to have unique values and make the one to many connection between the other two tables.
Now setup the following measure:
Banks = CONCATENATEX(tblBank;tblBank[Bank];",")
This will give you the setup for the bank information on a single row.
Create a table with the following setup:
Now create a tooltip page and add a table visual with the following setup:
Turn on the tooltip on the first table and setup the previous tooltip page on that see result below and on PBIX file attach.
You can set up the tooltip with other type of information not only a table and can be use on all other visuals.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @diederd ,
Create 3 dimension tables:
This tables will have to have unique values and make the one to many connection between the other two tables.
Now setup the following measure:
Banks = CONCATENATEX(tblBank;tblBank[Bank];",")
This will give you the setup for the bank information on a single row.
Create a table with the following setup:
Now create a tooltip page and add a table visual with the following setup:
Turn on the tooltip on the first table and setup the previous tooltip page on that see result below and on PBIX file attach.
You can set up the tooltip with other type of information not only a table and can be use on all other visuals.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMFelix.
Thank you for your prompt response and providing the much needed guidance to resolve my conundrum. Could I however ask as to how you went about getting the distinct table for your Transaction Table?
I'm working through your example but unable to fathom how you did it..
Thank you again for your help on resolving.
Hi @diederd ,
I have made a single step with all the links but you can the following approach on a blank query:
Check the code below:
let
Source = tblBank[Transaction code],
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Custom1 = tblStats[Transaction code],
#"Converted to Table1" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Appended Query" = Table.Combine({#"Converted to Table", #"Converted to Table1"}),
#"Removed Duplicates" = Table.Distinct(#"Appended Query")
in
#"Removed Duplicates"
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |