Can you use a tooltip in a table to display description
Is there a way to show additional data in a table for one field IF the field has conditional formatting to display a YES or NO? In the screenshot below, the Go to Green plan would have either a Yes or No displayed. The Yes, when clicked on or hovered over would display data pertaining to that project. Is this possible through tooltips? Table with Yes/No When Yes is selected or hover over, it would display the detail for that project.Fix Relationship for Distinct Count column and row values
I have a visual that uses a default Dataverse Direct query relationship. There a three departments from the related table as shown in department slicer. The main visual does show unique counts of the department of the related table, but the value of ONE of the department row (only it has a value of hrs = 4.00) are duplicated across all rows. Also all departments are listed as rows with no record counts. I need to only show the three Departments in the main visual with counts and total hrs in only the row that has the true total hrs.
TABLE VISUAL - NOT SHOWING CORRECT VALUE
Hello Everyone, I'm a newbiew working on a BI report, I want to show/display the header (Questions) as rows. Then categorize it now by 2 columns which is Manufacturer Rate & Supplier Rate. The concern is I use a filter to sort/display the result below by using the respondent category and supplier name. If this question was raise before and resolved please help me redirect to that same question. Appriciate any support provided. Sample I will use the following filter; Respondent = Manufacturer, Supplier = ABC Enterprise. The expected output should be like, on Question | Manufacturer Rate | Supplier Rate PPM's L12M | 6 | 7 Data Source Below: Respondent Category PPMs L12M: PPMs L12M Remarks: PPMs L3M: PPMs L3M Remarks: Sub-Tier Supplier Management: Sub-Tier Supplier Management Remarks: Manufacturer 6 TEST ONLY 9 TEST ONLY 1 TEST ONLY Supplier 7 TEST ONLY 7 TEST ONLY 2 TEST ONLY EXPECTED OUPUT: Questions: Manufacturer Rate Supplier Rate PPMs L12M 6 7 PPMs L3M 9 7 Sub Tier 7 2How to create a dynamic table? I got the error that column was not found in the input table :(
Hello experts! I have a table of Usage Logs and another table of Organization Info. I want to create a new dynamic table combining user_id and organization and also organization type. Because some user_id can be logged into different organizations, I need a table which will assign only one organization and organizational type to the user. Please see my table example as following: The usage logs is like the following: User_Id Organization Event 111 A Page Views 111 B Page Views 113 C ... The Organization Info is like the following: Organization Organization Type A Internal company B External company C External company The result I want to get is the following: (The logic is if a same user_id is logged in Organization A and Organization B, it will only count as a a user for the internal company and not external company.) User_Id Organization Organization Type 111 A Internal company 113 C External company Could some one help me to create a dynamic table? I tried the following but it doesn't work . The error message said the column 'Organization Type' specified in the 'Summazize' function was not found in the input table. Thanks a lot and I appreciate your help! DynamicTable = VAR UserTypes = SUMMARIZE('usage logs', 'usage logs'[user_Id], 'organization info'[Organization Type]) RETURN SUMMARIZE( UserTypes, 'usage logs'[user_Id], "Organization Type", SWITCH( TRUE(), CONTAINSSTRING(UserTypes, "Internal company") && CONTAINSSTRING(UserTypes, "External company"), "Internal company" BLANK() ) )
One store with two possible IDs, how do I relate the fact table and dimension table?
Hello fellow users! I've run into a small issue when dealing with my fact and dimension tables. In our franchise, we have two iFood stores for some of our operations (not all of them) for marketing reasons... The problem is that, for instance, I can't relate ID 85 to Store2, for instance. Below is an example of how my fact table looks: And here is an example of my dimension table: As you can see, some of the stores don't have a second ID. Any ideas on how I could relate these informations?
