Sep 131 min readHow to Display the Number of Rows in a Power BI Table Visual?Power BI, despite being a powerful tool, can have some frustrating limitations. A common example is the inability to directly display the...
Jun 301 min readOn PowerApps, how to fill a Combo box with a default value?This is a quick, but tricky one. Suppose you have a Vertical Gallery to allows users to edit data from a table in the app's database. The...
Mar 12, 20231 min readHow to include total in a bar chart?Let's imagine you have a bar chart with the % of people that likes smashed potatoes by state. Something like this (fake data, off...
Mar 12, 20231 min readHow can I create a measure that uses another based on the value selected of a field parameter?So, here is the situation: a report with a bunch of visuals that uses a field parameter (let's call it FieldParameter), which groups two...
Mar 1, 20231 min readHow to write a DAX measure equivalent to SQL select.. in?I've worked with SQL for over twenty years, so it comes quite naturally to me. Sometimes it's easier to think in terms of SQL rather than...
Feb 12, 20232 min readHow to update a Power BI published report using data from a local (on-premisses) Postgres databaseSo imagine you have, as a datasource, a Postgres database installed in a local server. You have a report that is published in Power BI...
Oct 22, 20214 min readHow to create a simple UI project with login, session management and protected resourcesFull code: https://github.com/aleksvp2017/login Using: Vue; Vuetify Vue-Router Vuex I'm assuming you do have node installed (if you...
Jul 4, 20212 min readHow to create a simple UI project with routes using Vue / Vuetify / Vue-RouterFull code: https://github.com/aleksvp2017/simpleui Using: Vue; Vuetify Vue-Router I'm assuming you do have node installed (if you don't,...
May 30, 20212 min readHow to protect Node server endpoints, checking for JSON Web TokensFull code: https://github.com/aleksvp2017/secureroutes Using: Node.js; Express; express-bearer-token; jsonwebtoken I'm assuming that you...
May 22, 20211 min readHow to set a simple HTTP server with routes using Node and ExpressFull code: https://github.com/aleksvp2017/simpleserver Using: Node.js; Express. Assuming that you have Node instaled (if you don't, you...
Nov 25, 20201 min readHow to send a whatsapp message using Node.js and Twilio APIFull code: https://github.com/aleksvp2017/nodewhatsapp Using: Node.js; Twilio; Visual Studio Code. First things first. There are two ways...
Oct 26, 20202 min readHow to communicate between components in a Vuetify appFull code: https://github.com/aleksvp2017/infoflow Using: Vue/Vuetify: to construct de UI; Vuex: to share data between components; Visual...
Sep 30, 20202 min readHow to debug webpack-dev-server UI app with VS Code and ChromeFull code: https://github.com/aleksvp2017/debug Using: Vue: to construct de UI; Visual Studio Code: to write and debug the code; Chrome:...
Jun 16, 20202 min readHow to make a heatmap using Vue/Vuetify and chroma-jsFull code: https://github.com/aleksvp2017/heatmap.git Using: Vue / Vuetify: to construct de UI; Scalable Vector Graphics (SGV) html-tag...
May 20, 20201 min readHow to export a spreadsheet from a Vuetify data table using SheetJS js-xlsx moduleFull code: https://github.com/aleksvp2017/exportspreadsheet.git Using: Vue / Vuetify: to construct de UI; SheetJS js-xlsx: generate xlsx...
May 11, 20201 min readHow to process a spreadsheet using Node.js and SheetJS js-xlsx moduleFull code: https://github.com/aleksvp2017/processspreadsheet Using: Node.js: the runtime environment; SheetJS js-xlsx: read and parse...
May 1, 20202 min readHow to upload a file in a frontend Vue/Vuetify and receive it on Node.Js backendFirst, the backend part. Full code: https://github.com/aleksvp2017/uploadfile Using: Node.js: the runtime environment; Express: HTTP...
