2023-04-24

dynamic format strings for measures in powerbi

 Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Dynamic format strings overcome an inherent disadvantage of using the FORMAT function. That is, with FORMAT even numeric data types are returned as a string, which may not work with visuals that require numeric values, like charts. When using dynamic format strings, the measure keeps its data type and isn't forced to change to a string data type. This applies different format strings to the measure depending on the context.

2023-04-04

unconventional happiness

 https://markmanson.net/unconventional-happiness


Happiness cannot be found outside ourselves.

Rather, happiness is a journey, and it’s one that we have to actively choose every day

2023-03-20

nosocomiale

 https://www.libertatea.ro/stiri/familia-unui-deputat-de-49-de-ani-decedat-de-covid-in-2020-cere-1-000-000-euro-daune-spitalului-militar-unde-s-a-infectat-cu-4-bacterii-nosocomiale-4484477

deputatul PSD Sebastian Radu a ajuns în decembrie 2020 la unul dintre cele mai reputate spitale din România, acela care avea locuri rezervate pentru demnitarii de rang zero: Spitalul Militar din București. Era bolnav de COVID. Ce a urmat a făcut-o pe soția sa să se lupte în justiție. „Poate așa nu mai moare nimeni!”, spune Diana Paula Radu.
Citeşte întreaga ştire: Familia unui deputat de 49 de ani decedat de COVID în 2020 cere 1.000.000 euro daune Spitalului Militar, unde s-a infectat cu 4 bacterii nosocomiale

2023-03-01

core-js needs your help

 https://github.com/zloirock/core-js/blob/master/docs/2023-02-14-so-whats-next.md


2023-02-21

power bi tricks

 Power BI tricks I can’t live without — Part 1 | by Data Pears | Medium


1. Change Slicer Orientation

2. Matrix: Show values in rows instead of columns

3. Matrix: the pivot table dilemma

4. Organise your columns/measures into folders:

5. Shadows

6. Buttons: change colour on hover

7. The Top N filter

8. Enable search on slicer

9. Align Visuals

10. The average line

multi fact tables

 Power BI Modelling — Using a Multi-Fact Model | by Peter Hui | Towards Data Science

So maybe you are thinking of having a multi-fact table model, how do you go about doing this?

You will need to do the following. I have provided an example from the few points above.

  1. Identify the two fact tables — Budget vs Expenses
  2. Agree on the granularity — Monthly, with the ability to drill
  3. Identify the common dimensions — Region and Dates
  4. Link the dimensions — Only 1: Many joins

2023-02-20

exil

 https://www.scena9.ro/article/exil-alexandra-badea-teatru-tnb