olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
7 years ago
Status:
Accepted

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

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.

8 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    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 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi olimilo, 

     

    Thank you for you pbix file. :smileyhappy:

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

     

    Best Regards,
    Qiuyun Yu 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    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 

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    felixnicol
    Frequent Visitor

    Anonymous Today you are my hero!

     

    Your fix is so much better than the official answer.