Borja Mora Méndez · Power BI

Files
.pbix

Projects developed and shared on LinkedIn. Download the file, explore the data model and use it as a reference for your own Power BI developments.

20 files available Power BI Desktop Direct download
Project management
01.pbix
Interactive Gantt Chart — No custom visuals
100% native Gantt diagram with automatic "today" line, HTML tooltips and DAX logic controlling duration, overlap and task progress.
Gantt nativoProject managementTooltips HTMLDAX
02.pbix
Project status widget — Everything at a glance
Concentrates progress, owners and status in a single reading point. Progress bar in native SVG with interactive slicer and HTML-integrated team.
WidgetSVG nativoFull contextFast decisions
03.pbix
Budget control — Concentration and risk
Detect in seconds if the budget is concentrated in a few projects. Native Top N (1, 3 or 5), automatic DAX narrative and dependency risk reading.
Top N nativoDistribuciónDAX narrativeStrategic risk
Sales and commercial analysis
04.pbix
Column variation — Change visible instantly
Select two years and see the percentage variation directly on the bars. Highlights only relevant columns, dims the rest and adds labels that interpret the change.
Variación %Annual comparisonDynamic labelsDAX
05.pbix
Slicer that directs analysis — Doesn't filter, guides
The user decides which question to answer and the visual adapts. Profit, units and margin in one visual with interactive calendar and performance-driven colours.
Segmentador inteligenteAnalysis hierarchyDynamic coloursUX
06.pbix
Highlight without filtering — Context always present
Highlight the projects you care about without removing the rest. Immediately discover if one project concentrates a quarter of the total budget.
Highlight without filterFull contextPresupuestoTopN DAX
07.pbix
Extended bars — Movement is information too
Percentage variation vs previous month directly on each bar. Automatic colours and strong-jump indicators. You'll discover invisible peaks if you only look at the heights.
Monthly variationAutomatic indicatorsAnomalíasDAX
08.pbix
Profit vs Target — Compliance story
Adjustable target with dynamic parameter, months in green when they exceed it, automatic subtitle with a count of months that hit the goal and annual average line.
Dynamic targetComplianceAutomatic narrativeKPIs financieros
09.pbix
Average Sales — Each product against itself
Small multiples with fixed average line per product. Dynamic monthly highlight, comparative label with difference in units and percentage. Compare against the right context.
Small multiplesOwn averageRelative performanceDAX
10.pbix
Product vs Product — When one outperforms the other
Annual comparison + automatic quarterly zoom when selecting a year. Dynamic narrative label that summarises what happened. See how the result was built, not just the final result.
Quarterly zoomDynamic narrativeCompetitive analysisDAX
11.pbix
Column storytelling — See the change, not just the number
Dynamic tooltip explaining the change, native parameters, automatic best-year label. Detect the growth pattern without reviewing tables or doing mental calculations.
Narrative tooltipParámetros nativosAutomatic best yearDAX
12.pbix
Sales vs Targets — The dashboard that alerts, not informs
Each product directly shows its compliance level. See in seconds what's on track, what's below and how many require immediate action. No table review needed.
Compliance objetivoVisual alertsOperational decisionsDAX
Advanced techniques · Data Storytelling
13.pbix
Ranking with Data Storytelling — Dynamic TopN + RANKX
Reduce 10 bars to 2 and the reading changes completely. Dynamic TopN with RANKX, dimmed background and total focus on what matters. Clarity without losing context.
TopN dinámicoRANKXNoise reductionPower BI nativo
14.pbix
Visual zoom on outliers — The chart that doesn't lie
An outlier can make all other bars look the same. 4 DAX measures and visual layers generate a double zoom: the real magnitude of the large value and the differences between the rest.
OutliersDouble scale4 medidas DAXZoom visual nativo
15.pbix
Slope Chart — Evolución, variación, peso y ranking juntos
Small multiples where each product concentrates all its information in one block. Switch from units to revenue with one click and the ranking changes. Data Storytelling you understand faster.
Slope chart nativoSmall multiplesMetric switchingDAX avanzado
Input Slicer · Full series
16.pbix
Input Slicer I — You don't filter data, you choose which story to see
Input Slicer + Field Parameter + DAX working together. Define the context by typing, change the angle by choosing metrics and everything recalculates to maintain analysis coherence.
Input SlicerField ParametersDisconnected tableDAX avanzado
17.pbix
Input Slicer II — Top N, metrics and titles from one place
The user centralises all decisions in one place: Top N clients, country filter, chart that highlights automatically and titles that change dynamically with the selection.
Top N dinámicoTítulos dinámicosCentralised interactionData Storytelling

Files 18–20 — coming soon. Follow me on LinkedIn to know when they're published.