Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Experts,
I am experiencing some strange behavior of the Switch function in a matrix.
I am building a Cashflow statement report, and use a table for the rows (Level 1 and Level 2 names)
For the indiviual values I use Measures.
Via the Switch function, I place the correct Measures in the table at the position of the Level 1 and Level 2 items.
The strange things is that this works perfect for 99% of the items in the Switch table, but for the example below, I cannot get the value to display in the table (item [saldo liquide middelen]). The Switch itself works fine, as can be seen below. When I put a value of 1 in the Switch table for "saldo liquide middelen", the 1 is shown at the correct line in the report....
but when I put the Measure into this Switch table, the values remain blank.
When I create a new Matrix, using the same Level 1, Level 2, date selection and only the value for [saldo liquide middelen], I get the data displayed, but the Level 1 row name is "blank".
I can not understand what I am doing differently for this calculation that it act's differently than all other calculations that I place in the table via Measures...
The Measure itself (that works, as can be shown above) is as follows:
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |