User Profile
Pfin
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Power BI - Excel To Power BI - Report Style Help Needed
I'm trying to recreate a report in Power BI that has long lived in Excel for YEARS where the user can basically create the format that has been used. Any input on how to provide this same information on a one pager to provide same info would be greatly appreciated. In short, there is an X-axis (Segment/Size) and a Y-axis (Manufacturer). I need the report to place the data points (Model, Price, and Available Date) in the cells. This is a living table/report where current values can be updated, records removed, records added. It doesn't have to be this exact look / feel, but it needs to be easy to read similar to this and displayed on one page and printable. I have attached the example data and report below. Data Table Manufacturer Segment Model Price Available Date Chevrolet Mini Spark 12000 9/30/2025 Chevrolet Mini Bolt 9000 2/28/2026 Chevrolet Small Trax 22000 6/30/2025 Chevrolet Medium Malibu 24000 1/31/2026 Chevrolet Medium Blazer 27000 3/31/2026 Ford Small Fiesta 12000 12/31/2025 Ford Small Focus 10000 8/31/2025 Ford Large Taurus 19000 4/30/2025 Kia Mini Picanto 10000 8/31/2025 Kia Small Rio 14000 11/30/2025 Kia Large Cadenza 28000 7/31/2025 ReportCalculate Minimum Over Group and Get Associated Value For Calculation
I have a data set with car values (example data) where I want to calculate "Residual Pct" from the user's selected date go forward. This all starts with a drop down slicer for the user to select the starting "Qtr Date". Based on this selection, I need to capture the "Value" associated with that date. THEN, using that captured "Value" we calculate a "Residual Pct" for each quarter after and including the user's selected start date. This is done at the Make/Model level as well so it resets the initial value at the Make/Model level. In the example, the data is by quarter by Make/Model for 2 years. The user in the slicer drop down selects "4/1/2023". Given this selection, I need to capture "$19,000" for the Toyotal Camry and "40,000" for the Nissan Maxima. Finally, the "Residual Pct" is calculated for EACH quarter respective to each Make/Model but only starting with what the user selected as the "Qtr Date" in the slicer. Below is an example. I've tried numerous ways with examples but still can't resolve. Appreciate any help.Power BI - X Axis Change Date based on Slicer Value
How do I change the X-Axis to use TWO different date fields based on the user selection within another slicer? The Data.... The report only has SOLD and ON MARKET data. The slicer field is based on this one field, Status, and the choices are "Sold" or "On Market". Each record has a list date and a sold date. For the line graph.... If the slicer value selection is "Sold", then I want the X-Axis to use "Sold Date". If the slicer value selection is "On Market" then I want the X-Axis to use "List Date". I've looked at measures, Field Parameters and such, but for some reason I'm stuck. Might be paralysis by analysis! ThxPower BI Reports & External Users
I have been building Power BI reports, dashboards, etc... for use within our organization for some time. Now there are some dashboards we would like to provide to users outside of our organization. Where can I find information on this process from how this all works? From costs to licensing related to external users to report/data security? The reports/dashboards are NOT embedded within a web page, but just having external users outside of our organization have the ability to access our reports/dashboards. I've been searching but I get so many "close" results but for some reason it's never the starting point. Thank you!Power BI - Dynamically Change Column Name
I'm trying to take the data from Tables 1 & 2 to create a report based on selected Make/Model. The challenge is that each Make/Model has 3 fields for general value adjustments. In order to keep it consistent, I just call them ValueAdj1, ValueAdj2, and ValueAdj3. Using Table 2 which provides the actual name of the value adj by Make/Model/ValueAdj, I need to create a report and rename the ValueAdj 1-3 to their ACTUAL name. The first green report below shows The Toyota Camry. Then when you change the Make/Model to Nissan Altima, the 3 column headers are renamed to their corresponding ValueAdj header names per the reference table for Nissan Altima. I've researched this in detail and seen multiple possibilities including variables but I still get stuck. Any ideas?Ocultar columnas condicionalmente o el usuario selecciona columnas para el informe
Necesito ocultar condicionalmente una columna o aún mejor, deje que el USUARIO determine qué columnas se muestran en el informe. Mis usuarios son simplemente consumidores y NO técnicos en absoluto. Manipularán los filtros como máximo. Esto es muy difícil de explicar sin caminar, pero aquí está mi ejemplo... Ejemplo: Tengo un proceso que produce una tabla en la que el valor de las columnas varía en función de las "Opciones" seleccionadas para cada marca y modelo. En este ejemplo, para cada make/modelo hay 7 campos estáticos que SIEMPRE aparecerán. A continuación, dependiendo de la marca/modelo, habrá "Opciones". El usuario selecciona las "Opciones" que desea incluir en el informe. Cuando se selecciona "Ejecutar" (esto está fuera de Power BI), la tabla se genera en SQL Server con los 7 campos estáticos y los campos "Opciones" seleccionados (supongamos que se seleccionaron 5 "Opciones"). Necesito que mi informe de Power BI (1) muestre todos los campos de esa tabla (12 en este ejemplo) que podrían tener diferentes columnas de "Opciones" cada vez (es decir, la tabla es dinámica) que dependa de "Opciones" dependientes de la marca/modelo o (2) En una tabla maestra con todas las "Opciones" proporcionadas, encuentre una manera de permitir que el USUARIO seleccione qué columnas "Opciones" incluir en el informe. ¿Es posible incluso en Power BI?Conditionally Hide Columns OR User Selects Columns For Report
I need to conditionally hide a column or even better yet, let the USER determine which columns are shown in the report. My users are simply consumers and NOT technical at all. They will manipulate filters at most. This is very hard to explain without walking through, but here is my example... Example: I have a process that produces a table where the # of columns varies depending on the "Options" selected for each Make and Model. In this example, for each Make/Model there are 7 static fields that will ALWAYS appear. Then depending on the Make/Model, there will be "Options". User selects which "Options" to include in the report. When "Run" is selected (this is outside of Power BI), the table is produced in SQL Server with the 7 static fields and whichever "Options" fields were selected (let's assume 5 "Options" were selected). I need my Power BI report to either (1) show all fields in that table (12 in this example) which could have different "Options" columns each time (ie, table is dynamic) dependent on Make/Model dependent "Options" OR (2) In one master table with all "Options" provided, find a way to let USER select which "Options" columns to include in the report. Is this even possible in Power BI?
