Forum Discussion

utsavlexmark's avatar
utsavlexmark
Icon for Helper III rankHelper III
2 months ago
Solved

Formatting Value of Table

Hello All, I am displaying a Table in Power BI dashboard. In the table we are showing Impressions and Clicks; now it is easily understandable that numbers on Higher side. What I want show the data a...
Need Help
Tips and Tricks
  • Shahid12523's avatar
    Shahid12523
    2 months ago

    Absolutely. You can achieve that with DAX measure. Use ISINSCOPE () or HASONEVALUE (). It will return complete value for detail records and formatted value (e.g. 3 Million, 30 K) only in the Totals row. The table formatting cannot do it alone.

     

    Clicks Display =
    IF(
        ISINSCOPE('Table'[Campaign Name]),
        FORMAT(SUM('Table'[Clicks]), "#,##0"),
        FORMAT(SUM('Table'[Clicks]) / 1000, "0") & " K"
     
    Impressions Display =
    IF(
        ISINSCOPE('Table'[Campaign Name]),
        FORMAT(SUM('Table'[Impressions]), "#,##0"),
        FORMAT(SUM('Table'[Impressions]) / 1000000, "0") & " Million"
    )
Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
2 months ago

Absolutely. You can achieve that with DAX measure. Use ISINSCOPE () or HASONEVALUE (). It will return complete value for detail records and formatted value (e.g. 3 Million, 30 K) only in the Totals row. The table formatting cannot do it alone.

 

Clicks Display =
IF(
    ISINSCOPE('Table'[Campaign Name]),
    FORMAT(SUM('Table'[Clicks]), "#,##0"),
    FORMAT(SUM('Table'[Clicks]) / 1000, "0") & " K"
 
Impressions Display =
IF(
    ISINSCOPE('Table'[Campaign Name]),
    FORMAT(SUM('Table'[Impressions]), "#,##0"),
    FORMAT(SUM('Table'[Impressions]) / 1000000, "0") & " Million"
)
utsavlexmark's avatar
utsavlexmark
Icon for Helper III rankHelper III
2 months ago

Thanks Shahid, 

It is solving my purpose.

But it creates a small problem; 
I am trying to sort the table based on Impression - it is not working.

Any tips to solve that?

Regards

Utsav