Newbie Question - struggling to refer to values in another table
Hi I have two tables Table 1 - Production Contains record of products booked into the warehouse Timestamp Product Quantity 20/07/2021 13:45 ABC 2 20/07/2021 14:12 XYZ 32 20/07/2021 16:38 ABC 54 Table 2 - Weekly Targets Simply contains the target production per week Week Number Product Target 28 ABC 300 29 ABC 380 30 ABC 410 28 XYZ 60 29 XYZ 130 30 XYZ 110 I'm trying to display a series of guages - one for each product and for each day of the week, showing the numbers produced each day against the daily target based on the weekly target / 5 (So in week 28 we need to make 60 units of ABC each day to meet out target) I've manage to create the guages for each day of the week and each product from the 'Production' table I've also got the filters working so that I only use the production quantities for this week in each guage I can also - add a column to the 'Weekly Targets' table that contains the [Daily Target] - add a colum to the 'Production' Table that contains the Week Number for that entry but now I can't fathom out how to use the new 'Weekly Target'[Daily Target] values to set the target in the guage I feel a bit dim... Thanks ChrisTargets in KPI
Hi all, I am trying to build a KPI card, but stuggeling to connect my data model with an external target or maximum value for the distinct entries in my data. here is a view of my sample external data : Origin Name 1-W Target Ameenpur 0.0402 Asansol Depot 0.1967 Atmakuru 0.6037 Aurangabad Depot 0.2831 Bangalore-Bidadi-DPG 0.3301 I have relationship as: The measure I am giving KPI value for : 1-Way Distribution = DIVIDE( CALCULATE([Shipments],'Prototype Modeling_Freight'[Load Category]="1-Way"), CALCULATE([Shipments]) ,BLANK()) Here is a link to screen recording to my problem statement Thank youCell background colors and gauges not working in Power BI Report Server after toggling visibility
I'm migrating an existing SSRS 2014 report to Power BI Report Server. The report has an indicator gauge based on a lookup to a second dataset. There's also a toggle to expand a row group that's hidden by default, in which certain rows are highlighted based on a lookup to the dataset mentioned above. I made no changes to the gauges or the highlighting logic. Can someone explain what's going on here? Edit: Just in case the image above isn't displaying properly (and for search optimization), what's happening is that 1.) the exclamation mark indicator looks different in PBIRS than in SSRS 2014, then 2.) after I expand the row group under the indicator, it becomes an A in a square -- assumedly some sort of image issue, be it webfonts or missing raster file or something else. Also, 3.) the background highlight color in the detail row group (associated with the indicator) doesn't display at all in Power BI Report Server -- it just shows a normal white background.
