José Villalobos

149 Flips | 6 Magazines | 108 Likes | 1 Following | 1 Follower | @JosVillalob2015 | Keep up with José Villalobos on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “José Villalobos”

Transpose table column values

Member<p>Posts: 227<p>Registered:<p>Hello All,<p>I have a table which is having three columns as below.<p>Now i would like to conver this table as<p>Is it possible …

Power BI

Transpose with DAX

Frequent Visitor<p>Posts: 14<p>Registered:<p>- edited<p>Hi all,<p>I have calculated new columns (week17-week20) with DAX formulas from another table ('Excel').<p>( …

Databases

HTML5 & JS Waterfall Chart

Waterfall Charts are same as column charts except that the base of next column starts from the end value of previous column. Waterfall chart helps in …

Data Visualization

Using Power BI to Report on Rich Text Data Fields in SharePoint

This post is the fourth in a series exploring Power BI and complex data types in SharePoint. It discusses working with using Power BI to report on …

Power BI Custom Visuals - HTML Viewer

The HTML Viewer Power BI Custom Visual allows you to display the results of HTML code within your Power BI reports.

Power BI

HTML Viewer

Beautifully render your data in HTML or plaintext. This visualization allows you to display your HTML text string (e.g. rich-text columns from …

Embedding a html site in the Power BI Dashbord

Frequent Visitor<p>Posts: 11<p>Registered:<p>Is it possible to embed a html site in the dashbord of Power BI desktop, perhaps by using the "+ Add tile" …

Power BI

think-cell :: Cómo automatizar gráficos en PowerPoint con datos de JSON

Puede utilizar datos en JSON para duplicar gráficos creados primero como plantilla y suministrarles una nueva hoja de datos. Puede controlar el orden …

Excel – Applying Conditional Formatting to Charts

Hopefully you are familiar with applying conditional formatting to cells, and creating rules to apply more complex formatting rules. If not, check …

Data Visualization

Using Email Attachments As A Data Source In Power BI

Many of my customers get the source data for their Power BI reports – usually Excel or csv files – sent to them as an email attachment on a regular …

Export PowerQuery query to CSV

Recently I found a PowerQuery gem, trick with Java/VB Script that allows to <b>export data from Power Query to CSV</b> without R / DAX Studio / SMS and …

Power BI – Publish to Web to Remove Grey area on the sides

I was recently browsing the Power BI Forums, where I enjoy helping others with Power BI questions. Not only that, I also learn from other people in …

Power BI

Using Power Query for Extracting Non-Tabular Data from Web Pages

Matt Here: I first met Ivan via Twitter when he was living in Russia, and then in person when he moved to Australia to live in Sydney with his …

Power BI

British divers make contact with missing Thai football team

Rescuers working on plan to free boys and their coach from flooded cave after dramatic discovery<p>Rescuers are working to free 12 boys and their football coach who have been found alive nine days after going missing in a flooded cave in Thailand.<p>Dramatic video shared on the Facebook page of the Thai …

Thai Navy

Adding Comments & Sending Emails in Power BI using PowerApps

A couple of days ago, a new custom visual was released for Power BI – PowerApps (in preview mode). As mentioned in the team blog, there are a ton of …

How to block ads on EVERY DEVICE in your home

Hello imgur. In light of all the recent controversy surrounding inline and embedded ads on the imgur site and app, I though I should share something …

Qué hacer si es detenido en un aeropuerto de EEUU

Mantenga la calma y verfique con el agente la causa de su detención para busca ayuda específica<p>Hay que tener en cuenta que <b>un viajero que ingresa o</b> …

Introducing Metadata-Driven Retention

Apply metadata-based policies to meet business, legal and regulatory mandates around data retention.<p>Across different industries, legal and regulatory …

Data Driven Companies: Skills, Tools and Culture

By Ana Maloberti, Data Architect @ Big Data Studio<p>It has been said many times that <i>data is the new oil</i>. However, it is not something you have to dig …

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

<i>Watch this week’s episode on YouTube.</i>In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning about Power BI.Power …

A generic SWITCH-function for the query editor in Power BI and Power Query

Although you can easily replicate the DAX SWITCH-function via list-, table- or record functions in M, I thought it would be convenient for many …

Efecto de la licencia moral: si nos dicen que somos buenos, seremos menos buenos

Parece, desde la psicología social, que las personas queremos ser respetadas y que nos consideren buenas personas, no malas.<p>Sin embargo, también …

El truco de los cinco minutos para combatir la procrastinación

Todos somos víctimas, en mayor o menor medida, de la <b>procrastinación</b>, la tendencia a postergar una tarea, hasta que nos pilla el calendario y acabamos …

Advanced Excel Formulas - 10 Formulas You Must Know!

10 Advanced Excel Formulas You Must Know<p>Every financial analyst spends more time in Excel than they may care to admit. Based on years and years of …

Analytics

Migrate a Power Query or Power BI file to a local SSAS instance

In Visual Studio there is a wizard to migrate an Excel Power Pivot model to a SSAS model. But this will not bring over the M-queries unfortunately. …

Databases

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI-Blog | Microsoft Power BI

Two of the new features in the Power BI Desktop April Update are Query Parameters and Power BI Template files. In this blog post, we will take a …

How does a data-driven organization set up a new office? Exploring Best Practices with reporting and analytics expert, Klipfolio

OTTAWA, Ontario, April 3, 2018 /CNW/ -- Setting up a new office can be an exciting, yet intimidating endeavor, especially if you're relocating from …

Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often …