Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
diederd
Helper II
Helper II

Tooltip with multiple fields (sorting in descending order)

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.

 

Sample.xlsx 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @diederd ,

 

Create 3 dimension tables:

  • Calendar
  • Transaction
  • Companies

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:

  • Companies[Company]
  • DimDate[MonthYear]
  • [Banks]

 

Now create a tooltip page and add a table visual with the following setup:

  • tblBank[Bank]
  • tblBank[Fee paid (LCY)]

 

Turn on the tooltip on the first table and setup the previous tooltip page on that see result below and on PBIX file attach.

tooltip.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @diederd ,

 

Create 3 dimension tables:

  • Calendar
  • Transaction
  • Companies

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:

  • Companies[Company]
  • DimDate[MonthYear]
  • [Banks]

 

Now create a tooltip page and add a table visual with the following setup:

  • tblBank[Bank]
  • tblBank[Fee paid (LCY)]

 

Turn on the tooltip on the first table and setup the previous tooltip page on that see result below and on PBIX file attach.

tooltip.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix.

 

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:

 

  • Add a blank step with the syntax = tblBank[Transaction Code]
  • Add a blank step with the syntax = tblStats[Transaction Code]
  • Now do an append between both previous steps
  • Remove duplicates

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.