Display issues with multirow card with text values (category missing, incorrect order of fields)

[olimilo]

I was trying to use the multi-row card to display several measures in my dashboard and it came to a point where I have to use it as a makeshift label. To my surprise, the multi-row card doesn't play nice with text values in measures.

This is the measure that I am trying to display in the multi-row card. Notice how the category label ("Revision (label)" seemingly disappear.

The [Reports Revised] measure is just a simple COUNTROWS measure, with a whole number format value. The category label displays properly in this case.

I then swapped it with a number-to-text converted [Error Rate] measure to test if it's working fine (I can use percentages just fine, but please note that I have to combine both measures in a format similar to the first screenshot). This time, the category label does not display properly.

Below is the multicard with several measures displayed. The first measure displayed is the text-value [Revision (label)] measure, the other is a number-value [Reports Reviewed] measure. Due note that in the Fields pane of the visual, the first item there is the [Reports Reviewed] measure and the [Revision (label)] is the last, but the [Revision (label)] measure shows up as the very first measure in the visual.

This behavior is very unusual and I would think that the visual should treat the values of whatever fields are fed into it uniformly, and that it should show them in the order that they were plugged into the visual.

[v-qiuyu-msft]

Hi @olimilo, 

Would you please use some dummy data to create a sample pbix file and share it with us? 

You can upload the pbix file to your OneDirve and paste the share link here. 

Best Regards,
Qiuyun yu 

[olimilo]

Hi @v-qiuyu-msft 

Here you go: https://send.firefox.com/download/292b56013f/#2rsVVKpzy8SD_TAcJzkIyg

As you can see, even with a report built from scratch, the bug still persists. I'm using this build: 2.67.5404.581 64-bit

[olimilo]

Hi @v-qiuyu-msft 

Were you able to download the file from earlier? I reuploaded the PBIX on Send.

https://send.firefox.com/download/edbca5bde6/#UqLPfqoq6C0A2-lnfsoDdw

Thanks

[v-qiuyu-msft]

Hi @olimilo, 

Thank you for you pbix file. 

I have reported this issue internally: CRI 111775373. Will keep you update once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @olimilo,

I got information below: 

"By Design. The MRC visual will group by the first Dimension field and repeat across the categories. It is by design to ignore the field name and promote it to the top as the primary grouping header. Any changes to this logic would break many customers and many existing visuals/reports, we cannot make the requested change."

Best Regards,
Qiuyun Yu 

[JDro]

Late to the game here but for anyone else to comes across this there is a proper solution on the XXLBI Blog which worked for me:

Setting the text measure you want to display as a variant data type like so allows PowerBI to detect the measure as a number and thus your category will appear:

Some text = IF(TRUE, "a", 1)

[felixnicol]

@JDro Today you are my hero!

Your fix is so much better than the official answer.