Power BI

Power BI
31 de octubre de 2022

How to write a C# script for Tabular Editor (part 1)

Well, well, this is another article about C# Scripts. A topic that deserves much more attention than it's getting. If you haven't read my previous post, go do it right now because otherwise writing a c# script is a very frustrating experience. Not as much as building a Data Factory pipeline as a new...
Leer post →
Power BI
8 de octubre de 2022

Writing Tabular Editor C# Scripts like a Boss

A few months back I wrote an article of what I thought would change the way I (and many more I thought) would write c# scripts from now on. In that article I explored the possiblity of creating a custom dll with all the classes and methods that would make my scripts shorter, more robust[...]
Leer post →
Power BI
17 de septiembre de 2022

A dynamic legend for a dynamic measure + time intel chart

Well it's no secret that I like calc groups. But it's also true that calc groups have an achiles heel. Calc Item names are constant, so for charts, legends stay the same no matter what. Depending on your use case you might get away with it, but sometimes you might get an end user that[...]
Leer post →
Power BI
14 de septiembre de 2022

Activating inactive relationships the smart way

Hi, today I want to talk about inactive relationships. Those relationships with the dashed line that unless you invoque them with USERELATIONSHIP they do nothing. The thing is a common pattern if you read this blog -- let's say you have a retail model, and for some charts you need to use the order d...
Leer post →
Power BI
10 de septiembre de 2022

Defining different formats for values and totals

So today I recevied a question on the SML group which looked like the perfect use case for a calculation group. Somebody was trying to build a matrix and wanted to have the values without decimals but the totals with decimals. In other words the goal was defining different formats for values and tot...
Leer post →
Power BI
28 de agosto de 2022

Building a fading bar chart

As soon as I learned how to define transparency in HEX encoding for Power BI, I started thinking on how to control it with a calculation group. After all, you can only define transparency through a color measure, so it made sense. If you have seen any of my most recent presentations on Calculation G...
Leer post →
Power BI
25 de julio de 2022

Building an arbitrary YOY% growth chart with zoom-out tooltips

I realize that I use the word "arbitrary" a lot on my blog posts, but then I think, "so what?". Anyway, this blog post is mostly a remake on another blog post, the one called "A truly dynamic tooltip". When I wrote that blog post, I had struggled a lot to get the effect I[...]
Leer post →
Power BI
13 de julio de 2022

Controlling Calculation Items with RLS

I thought I would let the blog rest for a few days, but I figured out I would write a short one on a topic that Rick brouhgt up on LinkedIn: Controlling Calculation Items with RLS. I lived under the impression that being a table you could just apply RLS like in any other table,[...]
Leer post →
Power BI
12 de julio de 2022

Data Validation with Power BI

I know, I'm back again at validations, but this time is a bit different. Recently I've found myselft in a project where the data that was coming in was not fulfilling the sepcified requirements. We tend to thing that data that comes out of a system will always be pristine, but well, at least in[...]
Leer post →
Power BI
28 de junio de 2022

Normalizing conditional formatting bars

Ok, this is one of those things that I might not do in production unless I have the CEO shouting on my ear "I want the bars of the matrix to be smaller so I can read the numbers, and no, you may not use a custom visual for that!". I know that might be[...]
Leer post →